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
This Blog gives informations about the databases Microsoft Sql Server,Mysql,Oracle, PostgreSQL delete duplicates,database creation in oracle,recover password in mysql,bulk copy program in sql server,sql server download
Friday, December 9, 2011
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment