DESCRIBE SAVED QUERIES LIST

The DESCRIBE SAVED QUERIES LIST command creates a list of all of your saved queries.

See also: SAVE QUERY, EXECUTE SAVED QUERY, DROP SAVED QUERY, RECOMPILE SAVED QUERY, and DESCRIBE SAVED QUERY

Note

DESCRIBE commands use CPU to increase usability.

Syntax

DESC[RIBE] SAVED QUERIES LIST [ DATABASE <database_name>] [ LIKE '<pattern>' ]

Parameters

Parameter	Parameter Type	Description
DATABASE	Identifier	Filters by a specific database
LIKE	STRING literal	String pattern to match

Output

Parameter	Description	Data Type
save_query_name	Name of the saved query	TEXT

Examples

DESCRIBE SAVED QUERIES LIST;

save_query_name   |
------------------+
cool_heavy_animals|
select_all        |

DESCRIBE SAVED QUERIES LIST database master LIKE 'select%';

save_query_name|
---------------+
select_all     |

Permissions

This command requires SUPERUSER permission, except when a role queries its own saved queries.