Shavonne Marietta Wijesinghe escreveu:
Hello
I have a db in MS Access 97 and now i have to import the data in
PostgreSQL. I can create the table structure in PostgreSql but in what
format can i export the table from Access so Postgresql can read it?
Thanks
Shavonne
Export the data, instea
Thanks.. So it was a uppercase problem ;)
Shavonne.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
On Thu, Mar 27, 2008 at 11:06 AM, Shavonne Marietta Wijesinghe
<[EMAIL PROTECTED]> wrote:
> COPY REGIONI FROM
(...)
> Strange coz i created the table. Why doesn't it seem to find it??
>
> CREATE TABLE "REGIONI"
You need to quote the name in your COPY command as well.
--
Sent via pgsql-sql mail
Strange coz i created the table. Why doesn't it seem to find it??
CREATE TABLE "REGIONI"
(
"AREA" int4,
"PERIMETER" int4,
"REGIONI_" int4,
"REGIONI_ID" int4,
"COD_REG" int4,
"REGIONE" text
)
WITHOUT OIDS;
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to yo
On Thu, 27 Mar 2008 10:03:57 +0100
"Shavonne Marietta Wijesinghe" <[EMAIL PROTECTED]>
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 "r
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)
1360077,00 848351,00 2
Shavonne Marietta Wijesinghe wrote:
Hello
I have a db in MS Access 97 and now i have to import the data in
PostgreSQL. I can create the table structure in PostgreSql but in
what format can i export the table from Access so Postgresql can read
it?
csv would be the most common and easiest.
Basi
On Wednesday 26 March 2008 11:46:43 Shavonne Marietta Wijesinghe wrote:
> Hello
>
> I have a db in MS Access 97 and now i have to import the data in
> PostgreSQL. I can create the table structure in PostgreSql but in what
> format can i export the table from Access so Postgresql can read it?
>
> Th
