diff -r bc69eca59041 -r 203be9022b46 pgtoolkit/pgbrowser.py --- a/pgtoolkit/pgbrowser.py Fri Aug 19 17:08:34 2011 +0200 +++ b/pgtoolkit/pgbrowser.py Tue Sep 06 17:55:15 2011 +0200 @@ -208,9 +208,10 @@ ORDER BY 1; ''', schema) - def list_columns(self, table, schema='public'): + def list_columns(self, table, schema='public', order=2): return self._query(''' SELECT + a.attrelid, a.attname as "name", format_type(a.atttypid, a.atttypmod) AS "type", a.attnotnull as "notnull", @@ -222,8 +223,7 @@ LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_catalog.pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE n.nspname = %s AND c.relname = %s AND a.attnum > 0 AND NOT a.attisdropped - ORDER BY 1 - ''', schema, table) + ORDER BY ''' + str(order), schema, table) def list_constraints(self, table, schema='public'): return self._query('''