Re: SHOW TABLES

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

> Well, if you put information_schema in the default path, it'd be
>
> SELECT * FROM TABLES;

Except it also shows views[1]. Oh, and it has a bunch of other arcane
and unwanted columns. Which we can't remove, nor can we add additional
columns to it, because it was specified by the standard, which
means that it was designed by committee and thus ugly and unusable
for most things.

[1] Granted, it would at least *tell* you its a view, unlike
MySQL's SHOW TABLES. On the other hand, no owner as per \dt

P.S. What's with the uppercase mania in this thread? Can we
please get back to saying "select * from tables"
and "show tables"? :)

- --
Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkw/WA0ACgkQvJuQZxSWSsilEwCgqo8OefwS2B65JnJjH9xLVhp0
R2wAoPtuMxSPvVKfZ19yBDo8as59p7lv
=YmAb
-----END PGP SIGNATURE-----