sql query to get field types

[Alexander Cohen]

What sql query can i use to get all relative data to the types of
fields that a table contains?
--
Alexander Cohen
http://www.toomuchspace.com
[phone]
[phone]
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[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