Re: How to display structure of a table

Поиск
Список
Период
Сортировка
От Chris Green
Тема Re: How to display structure of a table
Дата
Msg-id 20041125104733.GK539@areti.co.uk
обсуждение исходный текст
Ответ на How to display structure of a table  (Nageshwar Rao <NageshwarR@PLANETASIA.COM>)
Ответы Re: How to display structure of a table  (Chris Green <chris@areti.co.uk>)
Список pgsql-general
On Thu, Nov 25, 2004 at 04:08:30PM +0530, Nageshwar Rao wrote:
>    I have created a table and would like to display the structure to find
>    out datatype and length.
>
>    Just like in Oracle describe table_name;

in psql:-

    \dt

Basically the \d commands in psql give you much of what DESCRIBE does
for Oracle and mysql.  \? to see all the \ commands.

--
Chris Green (chris@areti.co.uk)

    "Never ascribe to malice, that which can be explained by incompetence."

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

Предыдущее
От: "Robert Soeding"
Дата:
Сообщение: Benchmark-Comparison PostGreSQL vs. SQL Server
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: [HACKERS] Help!