Thread: select as
View Single Post

   
  #1 (permalink)  
Old 04-08-2008, 06:35 PM
Bambero
 
Posts: n/a
Default select as

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Reply With Quote