Re: Fetching column names for a table - Mailing list pgsql-general

From Philip Hallstrom
Subject Re: Fetching column names for a table
Date
Msg-id 20050921114525.H87170@wolf.pjkh.com
Whole thread Raw
In response to Fetching column names for a table  (Steve Manes <smanes@magpie.com>)
List pgsql-general
> I need to extract a SETOF column names for a table in plpgsql.  How is this
> done?

Start up psql with the -E option.  Then type "\dt tablename".  This will
print out the SQL that psql runs to give you the column names.  Maybe that
will do what you want?

-philip

pgsql-general by date:

Previous
From: Yonatan Ben-Nes
Date:
Subject: Re: Slow search.. quite clueless
Next
From: Tom Lane
Date:
Subject: Re: Problem with libpq3 & postgresql8