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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Thu, 27 Mar 2008 10:03:57 +0100
  • Message-id: <004a01c88fe9$7dc58df0$0602a8c0@DREAM> <text/plain>
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
Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group