Monday, 8 August 2011

Learning pg

SHOW TABLES is
SELECT table_schema, table_name FROM information_schema.tables ;

SHOW DATABASES is
SELECT table_schema, COUNT(*) AS num_tables FROM information_schema.tables
GROUP BY table_schema;


use /? to find out how to do it properly.
Post a Comment