Skip to content

Instantly share code, notes, and snippets.

@sumitsahoo

sumitsahoo/see_user_tables.sql

Created July 15, 2020 07:59
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 sumitsahoo/a3c64115a11fbc44cad2b93787be8f28 to your computer and use it in GitHub Desktop.
Save sumitsahoo/a3c64115a11fbc44cad2b93787be8f28 to your computer and use it in GitHub Desktop.
Download ZIP
See all user defined tables in PostgreSQL
Raw
see_user_tables.sql
SELECT
*
FROM
pg_catalog.pg_tables
WHERE
schemaname != 'pg_catalog'
AND schemaname != 'information_schema';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment