On Thu, 15 Jul 2010, Peter Eisentraut wrote:
On tor, 2010-07-15 at 17:35 +0100, Simon Riggs wrote:
There should be one command to "display a list of tables" and it needs
to be easily guessable for those who have forgotten.
Well, if you put information_schema in the default path, it'd be
SELECT * FROM TABLES;
mre like:
SELECT * FROM TABLES WHERE not a system table or information schema table;
if we want to get *somewhere* close to \d ...
----
Marc G. Fournier Hub.Org Hosting Solutions S.A.
[email protected] http://www.hub.org
Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:[email protected]
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
