On 4/2/06, Christopher Browne <[EMAIL PROTECTED]> wrote:
where table_type='BASE TABLE'
if you need tables only otherwise it returns the Views also.
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] ("Andy Shellam") belched out:
> Is there an SQL command supported by Postgres to return a list of tables in a database?
Yes, it's called SELECT.
There is a standard schema called INFORMATION_SCHEMA, which contains a
variety of relevant views.
Notably, you could request:
SELECT * FROM INFORMATION_SCHEMA.TABLES
where table_type='BASE TABLE'
;
if you need tables only otherwise it returns the Views also.
That has the merit of actually conforming to SQL standards...
--
output = reverse(" moc.liamg" "@" "enworbbc")
http://cbbrowne.com/info/
They have finally found the most ultimately useless thing on the web...
Found at the Victoria's Secret website:
"The online shop: Text Only Listing"
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
