Postgres Pro
Downloads
Home   >   mailing lists

Re: query on table name to return columns and data types? - Mailing list pgsql-general

From Erik Jones
Subject Re: query on table name to return columns and data types?
Date
Msg-id 4582E553.80603@myemma.com
Whole thread Raw
In response to query on table name to return columns and data types?  ("blackwater dev" <blackwaterdev@gmail.com>)
List pgsql-general
Tree view 
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)

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: query on table name to return columns and data types?
Next
From: "Paul Khavkine"
Date:
Subject: FreeBSD shared memory settings