I have a list of cities stored in flat file that I would like to left join with another table.
The file looks like this:
I want to put them into a table like this:
I don't actually want to store them into the data base. I just want to get the above table with a select statement.
At the moment I'm using this statement which I feel is rather ugly:
select 'city1' union select 'city2' union select 'city3'
Is there a way of putting a text list into table form without using a bunch of unions? Like a row separator (RS)?
So I can do something like
Thanks for any help
pgsql-novice by date
|Next:||From: Rob||Date: 2006-01-26 18:25:14|
|Subject: Charting postgres schemas and table data into Kivio|
|Previous:||From: Jaime Casanova||Date: 2006-01-25 22:02:56|
|Subject: Re: block transactions in stored procedures|