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

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

pgsql-sql by date

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

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