Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group