On Thu, 2010-07-15 at 13:16 -0300, Marc G. Fournier wrote:
> I'd rather write:
>
> SHOW TABLES;
>
> then:
>
> SELECT table_name
> FROM information_schema.tables
> WHERE table_type = 'BASE TABLE'
> AND table_schema NOT IN
> ('pg_catalog', 'information_schema');
>
> And, the latter, unless I'm doing it regularly, is alot harder to remember
> then the former ...
+1
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Training and Services
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
