Re: Object description at Client Window

Поиск
Список
Период
Сортировка
От Kumar
Тема Re: Object description at Client Window
Дата
Msg-id 007b01c3948a$de7800b0$7502a8c0@hdsc.com
обсуждение исходный текст
Ответ на Object description at Client Window  ("Kumar" <sgnerd@yahoo.com.sg>)
Ответы Re: Object description at Client Window
Список pgsql-sql
Дерево обсуждения
Hi ,
 
Jordan, thanks for ur reply. But I am not asking that.
 
I want to get all the column names of any table at the PgAdmin3 SQL Window. To make it more clear, actually i wanted to send the table name as the input parameter for a function and expecting the column names, data types, etc as the output.
 
Is there any command or any system table from that I could query the column names of a table (other than \d table name at the command prompt).
 
Kumar
----- Original Message -----
To: Kumar
Sent: Friday, October 17, 2003 11:50 AM
Subject: Re: [SQL] 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

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