Re: database and table listing

Поиск
Список
Период
Сортировка
От Richard Poole
Тема Re: database and table listing
Дата
Msg-id 20001101191616.S21112@office.vi.net
обсуждение исходный текст
Ответ на database and table listing  (steve@foxx.uklinux.net (Stephen Patterson))
Ответы Re: database and table listing  (Igor Roboul <igor@raduga.dyndns.org>)
Список pgsql-general
On Wed, Nov 01, 2000 at 07:00:12PM +0000, Stephen Patterson wrote:
> are there any SQL statements which I can type into the psql client to give
> a listing of available databases,

\l

available tables (within a database),

\d

> and to view the structure of a single table.

\d tablename


All of which is in "man psql"...

These aren't SQL statements themselves, but if you start psql with
"-E", you can see the SQL queries which are sent to the backend when
you use them.

Richard

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

Предыдущее
От: Marko Kreen
Дата:
Сообщение: Re: database and table listing
Следующее
От: Charles Tassell
Дата:
Сообщение: Two Postmasters on the Same Machine