GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Can we have a currencies table included ?  XML
Forum Index -> General
Author Message

Joined: 28/06/2010 14:18:33
Messages: 2

I have created and succesfully linked with foreign keys a currencies table. Do you think we should include this in GeoNames ?

Here is the code for it.

CREATE TABLE currencies (
isoalpha3 character(3),
symbol character varying(7),
currency_name character varying(120),
fractional_unit character varying(20)

ALTER TABLE ONLY currencies ADD CONTRAINT "pk_currencies" PRIMARY KEY (isoalpha3);

Data for this in the attached.

 Description The actual currencies file [Disk] Download
 Filesize 5 Kbytes
 Downloaded:  2244 time(s)

Who is General Error and what is he doing in my drive A:

Joined: 08/12/2005 07:39:47
Messages: 4157

I have added a link to this thread to the countryInfo.txt file

Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team