Re: [SQL] Object description at Client Window

[Jordan S. Jones]

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