From: Kumar <sgnerd@yahoo.com.sg>
To: Jordan S. Jones <list@racistnames.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Object description at Client Window
Date: Fri, 17 Oct 2003 14:14:17 +0530
Message-ID: <007b01c3948a$de7800b0$7502a8c0@hdsc.com> (raw)
References: <005401c39474$db9cf640$7502a8c0@hdsc.com>
<3F8F8A37.1010208@racistnames.com>
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 -----
From: Jordan S. Jones
To: Kumar
Cc: pgsql-sql@postgresql.org
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¤cy_c...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sgnerd@yahoo.com.sg, list@racistnames.com
Subject: Re: Object description at Client Window
In-Reply-To: <007b01c3948a$de7800b0$7502a8c0@hdsc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox