Paul Lambert <paul.lambert@xxxxxxxxxxxxxxxxxx> writes:
>> novice wrote:
>>> db5=> \copy maintenance FROM test.txt
> I don't think copy allows you to leave columns out of your input file -
> even if they belong to a sequence.
Well, it does, but you have to specify which ones are being provided,
eg \copy tab(col1,col4,col7, ...
But the long and the short of it is that COPY doesn't see any column
delimiters at all in this file. We're guessing as to what the OP
intends the columns to be, but whatever he wants, he needs something
other than an uncertain number of spaces to separate them ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
