Re: column names, types, properties for a table

Hello,
there is the view "columns" in the schema "information_schema" that
can give you most of the informations you need
( for PosgreSQL version >= 7.4.8 if I'm right).

SELECT *
FROM information_schema.columns
WHERE table_name = 'mytable';

See
http://www.postgresql.org/docs/8.0/interactive/infoschema-columns.html#AEN26185
or
http://www.postgresql.org/docs/8.0/static/infoschema-columns.html#AEN26185

Regards,
Thomas

Roger Tannous a écrit :

>Hi,
>
>Is it possible to issue an SQL query that lists column names, types (int,
>varchar, boolean, etc.), properties (like NOT NULL or UNIQUE)
>for a given table name ?
>
>
>Regards,
>Roger Tannous.
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam? Yahoo! Mail has the best spam protection around
>http://mail.yahoo.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: Don't 'kill -9' the postmaster
>
>
>