select as

From: Bambero <bambero(at)tlen(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: select as
Date: 2004-12-23 18:37:14
Message-ID: 41CB105A.5080602@tlen.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark 2004-12-23 19:56:26 update table with row locking
Previous Message Michael Fuhr 2004-12-23 18:20:29 Re: select as