I am running PostgreSQL 7.3.2 on RedHat 8. I have many large census tables
I need to import. I access the Linux box from my Windows 2000 machine via
Cygwin and can access PostgreSQL similarly via EMS PostgreSQL Manager. I
understand that a table must be created with the correct fields before
INSERT or COPY can be used, or before the data import wizard in EMS can be
used. My problem is that I have some very large tables with hundreds of
fields to import. Is there a way to get PostgeSQL to honor the database
schema from an MS Access database and create the appropriate fields on
import automagically?
Kurt
~~~~~~~~~~~~~~~~~~~~~~~~~
Kurt A. Menke
GIS Analyst/Programmer
Mailing Address
Earth Data Analysis Center
MSC01 1110
1 University of New Mexico
Albuquerque, New Mexico 87131-0001
Street Address
University of New Mexico
Bandelier West, Room 123
Albuquerque, NM 87131
Phone: (505) 277-3622 (ext. 239)
FAX: (505) 277-3614
email: kmenke(at)edac(dot)unm(dot)edu