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; 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