Thread: list of tables?
Hello I d like to know if it is possible to have the list of tables like we can do with psql with \dt thanks Guillaume
On Wed, 20 May 1998, The Hermit Hacker wrote: > > Hello > > I d like to know if it is possible to have the list of tables like we can do with psql with \dt > > thanks > -- list all and only tables/views... SELECT usename, relname FROM pg_class, pg_user WHERE ( relkind = 'r') AND relname !~ '^pg_' AND relname !~ '^xin[vx][0-9]+' AND usesysid = relowner ORDER BY relname; Jose'
Hello! I see this SELECT every other day in mailbox. Isn't it a FAQ? On Thu, 21 May 1998, Jose' Soares Da Silva wrote: > -- list all and only tables/views... > SELECT usename, relname > FROM pg_class, pg_user > WHERE ( relkind = 'r') > AND relname !~ '^pg_' > AND relname !~ '^xin[vx][0-9]+' > AND usesysid = relowner > ORDER BY relname; Oleg. ---- Oleg Broytmann http://members.tripod.com/~phd2/ phd2@earthling.net Programmers don't die, they just GOSUB without RETURN.
> > Hello! > > I see this SELECT every other day in mailbox. Isn't it a FAQ? Added to FAQ. See the web site for the most recent version. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)