On Tuesday 14 October 2003 10:53, B.W.H. van Beest wrote: > It seems so elementary, but how I get a list of which tables are > available in a database. I can't find an SQL command for this, but there > must be a way!
In psql use \d or \dt If you start psql with the -E flag it will show you how it does that. There are also a number of pg_xxx views that show this sort of thing (pg_tables, pg_indexes etc). I think these are covered in an appendix of the manuals. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
