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