DZone Snippets: postgre code http://snippets.dzone.com/posts Sun, 07 Sep 2008 05:06:56 GMT DZone Snippets: postgre code PostgreSQL table structure with Information_Schema http://snippets.dzone.com/posts/show/816 <code> <br />SELECT COLUMN_NAME, <br /> DATA_TYPE, <br /> CHARACTER_MAXIMUM_LENGTH, <br /> NUMERIC_PRECISION, <br /> NUMERIC_SCALE, <br /> IS_NULLABLE, <br /> SUBSTR(COALESCE(COLUMN_DEFAULT, ''), 1, 8) = 'nextval(' AS IS_AUTOINCREMENT, <br /> COLUMN_DEFAULT <br />FROM INFORMATION_SCHEMA.COLUMNS <br />WHERE TABLE_NAME = 'xxxxxxxx' <br />ORDER BY ORDINAL_POSITION <br /></code> Tue, 18 Oct 2005 17:50:04 GMT http://snippets.dzone.com/posts/show/816 ms_michel (Michel)