Guest User

Untitled

a guest
May 25th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. SELECT nspname||'.'||relname AS full_rel_name
  2. FROM pg_class, pg_namespace
  3. WHERE relnamespace = pg_namespace.oid
  4. AND nspname = 'yourschemaname'
  5. AND relkind = 'r';
  6.  
  7. SELECT table_schema||'.'||table_name AS full_rel_name
  8. FROM information_schema.tables
  9. WHERE table_schema = 'yourschemaname';
  10.  
  11. SELECT * FROM pg_catalog.pg_tables where schemaname="yourschemaname";
Add Comment
Please, Sign In to add comment