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
Re: Show tables query |
| Список | 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 по дате отправления: