00krishna · May 24, 2014 07:39
diff --git a/select_cols.sql b/select_cols.sql
 SELECT attrelid::regclass, attnum, attname
 FROM   pg_attribute
 WHERE  attrelid = 'myschema.mytable'::regclass
 AND    attnum > 0
 AND    NOT attisdropped
 ORDER  BY attnum;
	SELECT attrelid::regclass, attnum, attname
	FROM pg_attribute
	WHERE attrelid = 'myschema.mytable'::regclass
	AND attnum > 0
	AND NOT attisdropped
	ORDER BY attnum;