Message-ID: <00d401c394a7$9bc6eb60$7502a8c0@hdsc.com>
Reply-To: "Kumar" <sgnerd@yahoo.com.sg>
From: "Kumar" <sgnerd@yahoo.com.sg>
To: "Richard Huxton" <dev@archonet.com>,
	"Jordan S. Jones" <list@racistnames.com>
Cc: <pgsql-sql@postgresql.org>
References: <005401c39474$db9cf640$7502a8c0@hdsc.com>
	<3F8F8A37.1010208@racistnames.com>
	<007b01c3948a$de7800b0$7502a8c0@hdsc.com>
	<200310171024.17494.dev@archonet.com>
Subject: Re: Object description at Client Window
Date: Fri, 17 Oct 2003 17:39:52 +0530
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I am sorry. Yes it worked.
Thank you very much Mr. Jordan and Mr. Richard.

----- Original Message ----- 
From: "Richard Huxton" <dev@archonet.com>
To: "Kumar" <sgnerd@yahoo.com.sg>; "Jordan S. Jones" <list@racistnames.com>
Cc: <pgsql-sql@postgresql.org>
Sent: Friday, October 17, 2003 2:54 PM
Subject: Re: [SQL] Object description at Client Window


> On Friday 17 October 2003 09:44, Kumar wrote:
> > 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).
>
> Try what the man said. Start psql with -E and issue \d mytable and it will
> show you the SQL it uses to produce the table's details.
>
> -- 
>   Richard Huxton
>   Archonet Ltd