Re: [SQL] Off topic : world database

2003-03-27 Thread Bruno Wolff III
On Wed, Mar 26, 2003 at 16:55:21 +, Michael A Nachbaur <[EMAIL PROTECTED]> wrote: > > I for one would be very interested in such a web service (I'd really like a > address / street lookup to find lat/longs for addresses, but thats not likely > to happen). Its already there for the US. A g

Re: [SQL] Off topic : world database

2003-03-27 Thread Bruno Wolff III
On Thu, Mar 27, 2003 at 10:06:08 +1000, Rudi Starcevic <[EMAIL PROTECTED]> wrote: > > I've been searching for a source for this data without joy so far and > would like to > ask if someone on this list could point me to or help with a source for > this info. > Ideally I'd like Country,States,a

Re: [SQL] Complex outer joins?

2003-03-27 Thread Correia, Carla
Hi... Postgres 7.3 I'm using the copy command to fill my tables. I've got this file with the data with delimiter '\t' and 'isnull' for nulls as follows: copy mytable FROM '/usr/share/postgresql/data1/skripte/Daten/mytable' using delimiters '\t' with null as 'isnull'; But I receive an

Re: [SQL] Off topic : world database

2003-03-27 Thread Tomasz Myrta
Uz.ytkownik Rudi Starcevic napisa?: Hi, I have a slightly off SQL topic question which I don't think is too inappropriate, if it is please let me know and I'll not push my luck again of my *favorite email list*. I'd like to build a Postgresql database of Countries,States and Cities of the worl