Re: [NOVICE] column and table names

[John DeSoi <desoi@xxxxxxxxxx>]

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