Wednesday, October 27, 2010

How to retrieve information about a table on Postgres

To retrieve information (columns and types) about a table definition of Postgres

select column_name, data_type from INFORMATION_SCHEMA.COLUMNS where
table_name = 'domande';

Labels: , ,