sql query to get field types

#1

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
(819) 348-9237
(819) 432-3443

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

#2

On Mon, 1 Mar 2004, Alexander Cohen wrote:

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

sql query to get field types

comp.databases.postgresql.general comp.databases.postgresql.general

sql query to get field types - 03-01-2004 , 04:54 PM

Re: sql query to get field types - 03-01-2004 , 04:57 PM