Skip to content

Instantly share code, notes, and snippets.

@rkusa
Last active March 30, 2022 20:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rkusa/a101cf3bedbfd3266d834fc4dc6ca010 to your computer and use it in GitHub Desktop.
Save rkusa/a101cf3bedbfd3266d834fc4dc6ca010 to your computer and use it in GitHub Desktop.
SELECT VERSION();
---
SHOW ALL;
---
SELECT word, catcode FROM pg_get_keywords();
---
SELECT
oid
,nspname
,nspname = ANY (current_schemas(true)) AS is_on_search_path
,obj_description(oid, 'pg_namespace') AS comment
FROM pg_namespace;
---
SELECT current_schemas(true) as searchpath;
---
SELECT name, setting FROM pg_settings WHERE source = 'session';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment