Skip site navigation (1) Skip section navigation (2)

Re: Export Access 97 to PostgreSQL

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 (view raw or flat)
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


In response to

Responses

pgsql-sql by date

Next:From: Shavonne Marietta WijesingheDate: 2008-03-27 10:06:39
Subject: Re: Export Access 97 to PostgreSQL
Previous:From: Shavonne Marietta WijesingheDate: 2008-03-27 09:03:57
Subject: Re: Export Access 97 to PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group