Re: [GENERAL] importing into postgres

From: lynch(at)lscorp(dot)com (Richard Lynch)
To: Kevin Heflin <kheflin(at)shreve(dot)net>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] importing into postgres
Date: 1998-07-23 21:22:09
Message-ID: v02140b07b1dd10841152@[207.152.64.133]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)lscorp(dot)com

Browse pgsql-general by date

  From Date Subject
Next Message Brett W. McCoy 1998-07-23 22:01:46 Re: [GENERAL] How about this LOGO?
Previous Message Vadim Mikheev 1998-07-23 19:41:23 Re: [GENERAL] Fwd: help with uniq index (fwd)