Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT nspname||'.'||relname AS full_rel_name
- FROM pg_class, pg_namespace
- WHERE relnamespace = pg_namespace.oid
- AND nspname = 'yourschemaname'
- AND relkind = 'r';
- SELECT table_schema||'.'||table_name AS full_rel_name
- FROM information_schema.tables
- WHERE table_schema = 'yourschemaname';
- SELECT * FROM pg_catalog.pg_tables where schemaname="yourschemaname";
Add Comment
Please, Sign In to add comment