Re: Show tables query

Поиск
Список
Период
Сортировка
От Christopher Browne
Тема Re: Show tables query
Дата
Msg-id 878xqo9m8q.fsf@wolfe.cbbrowne.com
обсуждение исходный текст
Ответ на Show tables query  ("Andy Shellam" <andy.shellam@mailnetwork.co.uk>)
Ответы Re: Show tables query  ("Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>)
Re: Show tables query  ("Andy Shellam" <andy.shellam@mailnetwork.co.uk>)
Список pgsql-admin
After takin a swig o' Arrakan spice grog, andy.shellam@mailnetwork.co.uk ("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"

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Andy Shellam"
Дата:
Сообщение: FW: Show tables query
Следующее
От: "Rajesh Kumar Mallah"
Дата:
Сообщение: Re: Show tables query