Re: Export Access 97 to PostgreSQL - Mailing list pgsql-sql

From Shavonne Marietta Wijesinghe
Subject Re: Export Access 97 to PostgreSQL
Date
Msg-id 004a01c88fe9$7dc58df0$0602a8c0@DREAM
Whole thread Raw
In response to Export Access 97 to PostgreSQL  ("Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>)
Responses Re: Export Access 97 to PostgreSQL
List 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 



pgsql-sql by date:

Previous
From: Shawn
Date:
Subject: Re: Dropping Functions
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: Export Access 97 to PostgreSQL