From: | Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Cc: | "Shavonne Marietta Wijesinghe" <shavonne(dot)marietta(at)studioform(dot)it> |
Subject: | Re: Export Access 97 to PostgreSQL |
Date: | 2008-03-27 09:54:36 |
Message-ID: | 20080327105436.36e13506@webthatworks.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Thu, 27 Mar 2008 10:03:57 +0100
"Shavonne Marietta Wijesinghe" <shavonne(dot)marietta(at)studioform(dot)it>
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
From | Date | Subject | |
---|---|---|---|
Next Message | Shavonne Marietta Wijesinghe | 2008-03-27 10:06:39 | Re: Export Access 97 to PostgreSQL |
Previous Message | Shavonne Marietta Wijesinghe | 2008-03-27 09:03:57 | Re: Export Access 97 to PostgreSQL |