Re: Object description at Client Window

give psql -E a try.. It will display any internal SQL commands that it uses.

Jordan S. Jones

Kumar wrote:

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

-- 
I am nothing but a poor boy. Please Donate..
https://www.paypal.com/xclick/business=list%40racistnames.com&no_note=1&tax=0&currency_code=USD