On Thu, 27 Mar 2008 10:03:57 +0100 "Shavonne Marietta Wijesinghe" <[EMAIL PROTECTED]> wrote:
> Thanks. I tried the following command > > COPY REGIONI FROM > 'C:/Inetpub/wwwroot2/FORMWebSite1/database/FormAjax/REGIONI.copy' > WITH DELIMITER '\t'; > > But i get this error > > ERROR: relation "regioni" does not exist You've to create the REGIONI table. You may (or may not) get into trouble with locale. I noticed you're using , as a decimal separator. So if you're still encountering problems... that could be the second thing to look at. > Here is a sample of my file (fields seperated with a tab) > 13600770000,00 848351,00 2,00 2,00 4,00 "Trentino-alto adige" > 18424000000,00 1132202,00 3,00 3,00 5,00 "Veneto" > 7859928000,00 746082,90 4,00 4,00 6,00 "Friuli-venezia giulia" -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
