Answers for "postgres get all tables in schema"

get all tables postgres

SELECT * FROM pg_catalog.pg_tables;

Posted by: Guest on November-11-2020

list all tables in postgres schema

dt schema_name.*

Posted by: Guest on December-27-2021

postgres get all tables in schema

SELECT * FROM information_schema.tables 
WHERE table_schema = 'public'

Posted by: Guest on February-22-2022

Code answers related to "postgres get all tables in schema"