select as - Mailing list pgsql-general

From Bambero
Subject select as
Date
Msg-id 41CB105A.5080602@tlen.pl
Whole thread Raw
Responses Re: select as  (Michael Fuhr <mike@fuhr.org>)
Re: select as  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Hello

Is there any easy way to select all fields from table (*) but the result
should looks like this:

   1|    2|    3
----+-----+------
asas| asd | dasd
ada | ads | dasa

Column name should be a number of column.

I don't know what fields are in the table so:

select fieldname as 1, fieldname2 as 2

is useless.

Bambero

pgsql-general by date:

Previous
From: Lonni J Friedman
Date:
Subject: Re: monitoring tools
Next
From: "Jason Tesser"
Date:
Subject: Re: monitoring tools