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@edac.unm.edu