Object description at Client Window
| От | Kumar |
|---|---|
| Тема | Object description at Client Window |
| Дата | |
| Msg-id | 005401c39474$db9cf640$7502a8c0@hdsc.com обсуждение исходный текст |
| Ответы |
Re: Object description at Client Window
|
| Список | pgsql-sql |
Dear Friends,
I am working with Postgres 7.3.4 on RH linux 7.2.
I could get into the command prompt to describe a table structure.
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
training=# \d emp
Table "emp"
Column | Type | Modifiers
--------+-----------------------+-----------
no | integer |
name | character varying(20) |
age | integer |
Table "emp"
Column | Type | Modifiers
--------+-----------------------+-----------
no | integer |
name | character varying(20) |
age | integer |
training=#
But I wanted to know whether this description could be availed at the command prompt. I am using PgAdmin3. I have checked the systems tables also. pg_tables can tell us only the table and the columns inside tables.
Any idea to share with me, please. I am looking for something like sp_helptext in MS SQL server.
Regards
Kumar
В списке pgsql-sql по дате отправления: