Re: [GENERAL] importing into postgres

Richard Lynch <lynch@lscorp.com>

From: lynch@lscorp.com (Richard Lynch)
To: Kevin Heflin <kheflin@shreve.net>
Cc: pgsql-general@postgreSQL.org
Date: 1998-07-23T21:22:09Z
Lists: pgsql-general
create an import table with no id field, or rather, with a fake field that
will accept whatever you have in the file.

Then, do an:

insert into realTable from select * from importTable;

and let your auto incrementer do its job.

--
--
-- "TANSTAAFL" Rich lynch@lscorp.com