Re: Export Access 97 to PostgreSQL

From: "Shavonne Marietta Wijesinghe" <shavonne(dot)marietta(at)studioform(dot)it>
To: "Shawn" <postgres(at)xmtservices(dot)net>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Export Access 97 to PostgreSQL
Date: 2008-03-27 09:03:57
Message-ID: 004a01c88fe9$7dc58df0$0602a8c0@DREAM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

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"

What can the problem be?

Shavonne

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2008-03-27 09:54:36 Re: Export Access 97 to PostgreSQL
Previous Message Shawn 2008-03-27 00:25:21 Re: Dropping Functions