From: | "Brandon Aiken" <BAiken(at)winemantech(dot)com> |
---|---|
To: | <rloefgren(at)forethought(dot)net> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: serial, sequence, and COPY FROM |
Date: | 2006-09-12 18:48:30 |
Message-ID: | F8E84F0F56445B4CB39E019EF67DACBA2F1E55@exchsrvr.winemantech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Serial fields have a default value of nextval, so if you add an 18th
field to your text file with DEFAULT in every record it should work as
intended.
--
Brandon Aiken
CS/IT Systems Engineer
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of
rloefgren(at)forethought(dot)net
Sent: Tuesday, September 12, 2006 12:28 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] serial, sequence, and COPY FROM
All,
I have a pipe delimited text file I'm trying to copy to a table. The
file has 17 fields per line. The table has 18, with that last field
(record) a serial with sequence. I have done:
select setval('sequence_name_seq', 555, 'TRUE')
but when I do: COPY tablename FROM '/path/to/file/file.txt' delimiter
'|'
the copy stops at the first row, insisting that it's missing data for
the field record. Well, yeah...
I can make this work with inserts but not with COPY FROM. What I've
been doing is dumping it into a mysql table with an auto_increment
field and then dumping that into a text file and using that for the
COPY FROM; certainly clumsy. How might this be done?
r
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2006-09-12 18:54:23 | Re: serial, sequence, and COPY FROM |
Previous Message | John McCawley | 2006-09-12 17:47:06 | Re: Bytea to Text problems |