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
training=# \d emp
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
