From: Richard Huxton <dev@archonet.com>
To: 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 10:24:17 +0100
Message-ID: <200310171024.17494.dev@archonet.com> (raw)
In-Reply-To: <007b01c3948a$de7800b0$7502a8c0@hdsc.com>
References: <005401c39474$db9cf640$7502a8c0@hdsc.com>
<3F8F8A37.1010208@racistnames.com>
<007b01c3948a$de7800b0$7502a8c0@hdsc.com>
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
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: dev@archonet.com, sgnerd@yahoo.com.sg, list@racistnames.com
Subject: Re: Object description at Client Window
In-Reply-To: <200310171024.17494.dev@archonet.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