DESCRIBE SAVED QUERY

The DESCRIBE SAVED QUERY command returns the SQL syntax of a specific saved query.

Note

DESCRIBE commands use CPU to increase usability.

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

Syntax

DESC[RIBE] SAVED QUERY [ DATABASE <database_name>] NAME <"saved_query_name">

Parameters

Parameter	Parameter Type	Description
DATABASE	Identifier	Filters by a specific database
NAME	Identifier	The name of the saved query

Output

Parameter	Data Type	Description
sql	TEXT	The SQL syntax of the selected saved query

Example

DESCRIBE SAVED QUERY DATABASE master NAME "SelectAll";

sql
-----------------
SELECT * FROM nba

Permissions

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