Friday, December 9, 2011

Get tablename and schema names in PostGresql



select distinct schemaname from pg_tables where schemaname not in
('information_schema', 'pg_catalog');

select  schemaname,tablename from pg_tables

select tablename from pg_tables where schemaname='name_of_schema';

select * from pg_tables

No comments:

Post a Comment