Pgadmin - How to convert MS Access DB to PostgreSQL by pgAdminIII

Author

How to convert MS Access DB to PostgreSQL by pgAdminIII

e120358@metu.edu.tr

2005-09-22, 3:23 am

Hi,
I want to convert MS Access DB to PostgreSQL by pgAdminIII.
Can you explain the method to do it step by step please.
Thanks.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Hiroshi Saito

2005-09-22, 3:24 am

Hi

> Hi,
> I want to convert MS Access DB to PostgreSQL by pgAdminIII.
> Can you explain the method to do it step by step please.
> Thanks.

I recommend you using psqlODBC. The export function of a table will
help your thought, while opening it by MS-Access. Though regrettable,
pgAdmin does not have the function from III.

Regards,
Hiroshi Saito

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Hiroshi Saito

2005-09-22, 7:23 am

----- Original Message -----
From: <e120358@metu.edu.tr>

> Thanks for your answer. But I have another problem.
> I wonder that how can I get the path of the new created database by
> using the pgAdmin3. It is necessary because I need to it to set the
> path value of it in Regedit in Windows
>
> Thanks.

What situation is it? I think that any situations using regedit are unnecessary.
Possibly, when PostgreSQL is created for yourself, is it said that it is required
because of the place of pg_dump and pg_restore which pgAdminIII needs,
and postgresql.conf? regedit is not required although it admits that they must
take arrangement into consideration.

Regards,
Hiroshi Saito

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Sponsored Links