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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
