| 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: | Whole Thread | Raw Message | 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 |