| From: | Highway80 dude <pgsql_general(at)highway80(dot)net(dot)au> |
|---|---|
| To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Importing from Access: advice? |
| Date: | 2000-08-12 15:39:04 |
| Message-ID: | 39956F98.9010305@highway80.net.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have an Access97 database I would like to convert to pgSQL (about 50
tables). Is there a better way to do it than to have Access97 export CSV
files and then use the COPY command to import them? (I read the Bruce
Momjiam work in progress).
At the moment, I only have pg installed on my Linux box (version 7). Do
you think I should do a windows installation of PG and somehow import it
via ODBC ?
If i did this, would I simply be able to copy the datafiles across [from
the windows site to the linux site]. Does the windows version support
pg_dump (including the -o option)?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kari Lempiainen | 2000-08-12 15:59:27 | Plans to support database.table syntax? |
| Previous Message | Highway80 dude | 2000-08-12 15:26:58 | linking tables across databases |