Postgres Pro
Downloads
Home   >   mailing lists

Thread: query on table name to return columns and data types?

query on table name to return columns and data types?

From
"blackwater dev"
Date:
How can I run a query based on a table name and get the column names and data types returned?

Thanks!

Re: query on table name to return columns and data types?

From
"Joshua D. Drake"
Date:
On Fri, 2006-12-15 at 12:26 -0500, blackwater dev wrote:
> How can I run a query based on a table name and get the column names
> and data types returned?

Usually your language API will give you what you need for that.

Sincerely,

Joshua D. Drake


>
> Thanks!
--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

Re: query on table name to return columns and data types?

From
Erik Jones
Date:
blackwater dev wrote:
> How can I run a query based on a table name and get the column names
> and data types returned?
>
> Thanks!
Check out the columns view in the information_schema.

--
erik jones <erik@myemma.com>
software development
emma(r)