Try this:
select column_name from information_schema.columns where table_name =
'tablename' order by ordinal_position;
On Apr 26, 2007, at 6:11 PM, stephen wrote:
Thanks, that worked ;-( but is there any way of ordering the column
names by their natural order in the table - same as the order in the
view?
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
