| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "Kumar" <sgnerd(at)yahoo(dot)com(dot)sg>, "Jordan S(dot) Jones" <list(at)racistnames(dot)com> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Object description at Client Window |
| Date: | 2003-10-17 09:24:17 |
| Message-ID: | 200310171024.17494.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | stephan.rupp | 2003-10-17 10:39:02 | [postgres] IPv6-Datentyp(en) in PostgreSQL? |
| Previous Message | Kumar | 2003-10-17 08:44:17 | Re: Object description at Client Window |