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