Kevin,
Ref : Thursday, October 12, 2000 11:05:10 PM
KL> Does anyone know of a utility which can easily convert MS Access tables into
KL> Postgres?
KL> Alternatively, I can export to any format that MSAccess supports (e.g.
KL> comma-delimited text), but would like to know if there are any import
KL> utilities which will simplify the import process into postgres so I don't
KL> have to write a script for 100 fields X thousands of records.
KL> Thanks for your help!
KL> Kevin
RTFM !
1) Create a table in postgres
create table foo
(
name text,
phone text,
age integer
);
2) export your table in "tab" delimited format from access with the
fields in the same order as in postgres :
john 5551212 25
paul 5551313 26
georges 5551414 30
ringo 5551515 27
3) use "copy table from..." command
copy foo from myaccessexportfile.txt;
Look for "COPY" in the docs.
--
Jean-Christophe Boggio
cat@thefreecat.org
Independant Consultant and Developer
Delphi, Linux, Oracle, Perl