From: | Carol Walter <carol(dot)walter(at)sbcglobal(dot)net> |
---|---|
To: | Carol Walter <carol(dot)walter(at)sbcglobal(dot)net> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Copying data from a tab delimited file into a table |
Date: | 2014-02-11 19:21:47 |
Message-ID: | 571DE3B6-73CA-4302-A360-3185C00A9479@sbcglobal.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
FYI, I was able to do this with the COPY command which takes a field list as arguments. I don't know if the "\copy" command does or not, but I was able to use COPY and it worked.
On Feb 11, 2014, at 12:13 PM, Carol Walter wrote:
> I'm trying to copy the data from a tab delimited file into a postgres table. The table has a primary key that's designated as a serial data type. When I try to do the copy, it "blows up" unless I put a integer number in the field where the primary key will be. That defeats the purpose of designating this field as serial. When I put data into that field the copy works but an insert statement fails because it says there is a duplicate key. How can I get the data from this file into my table and still have the key field designated with a "serial data type"?
>
> Thanks,
> Carol
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
From | Date | Subject | |
---|---|---|---|
Next Message | Luca Ferrari | 2014-02-11 20:36:02 | Re: Copying data from a tab delimited file into a table |
Previous Message | James David Smith | 2014-02-11 17:16:22 | Re: Copying data from a tab delimited file into a table |