Re: [GENERAL] sql query to get field types

[scott.marlowe]

On Mon, 1 Mar 2004, Alexander Cohen wrote:

> What sql query can i use to get all relative data to the types of 
> fields that a table contains?

select column_name,data_type from information_schema.columns where 
table_name='test';

works in 7.4


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org