Обсуждение: When dealing with 'bigint'or 'int8', the command 'copy'doesn't work

Поиск
Список
Период
Сортировка

When dealing with 'bigint'or 'int8', the command 'copy'doesn't work

От
"Dong, Meng"
Дата:
SGkgZ3V5cywNCg0KSSBtZWV0IGEgcHJvYmxlbSB3aGVuIHRyeSB0byBpbXBv
cnQgZGF0YSBmcm9tIGEgVGFiLWRlbGltaXRlZC10ZXh0IGZpbGUgdG8gYSB0
YWJsZSBieSBjb21tYW5kICdjb3B5IGZyb20nLiBBIHNhbXBsZSBwcm9jZWR1
cmUgaXMgZXhwbGFpbmVkIGFzIGZvbGxvdywNCg0KDQpmaXJzdCwgSSBnZW5l
cmF0ZSBhIGZpbGUgY2FsbGVkICAvaG9tZS90ZW1wL3Rlc3QudHh0LCBsZXQn
cyBzdXBwb3NlIGl0IGhhcyBvbmx5IHR3byBsaW5lcywgKCB0aGUgZm91ciBm
aWd1cmVzIGFyZSBkZWxpbWl0ZWQgYnkgdGFiKQ0KMTIzICAgICA0NTYNCjc4
OSAgICAgOTk5DQoNClNlY29uZCwgSSB0eXBlIHRoZSBmb2xsb3dpbmcgY29t
bWFuZCB1bmRlciBQU1FMLA0KY3JlYXRlIHRhYmxlIHR0dCAoIGMxIGJpZ2lu
dCwgYzIgYmlnaW50KTsNCg0KRmluYWxseSwgSSB0cnkgdG8gaW1wb3J0IHRo
ZSBkYXRhIGZyb20gdGVzdC50eHQgaW50byB0YWJsZSB0dHQgYnksDQpjb3B5
IHR0dCBmcm9tICcvaG9tZS90ZW1wL3Rlc3QudHh0JzsNCg0KDQpCdXQgSSB3
YXMgdG9sZCwNCkVSUk9SOiAgY29weTogbGluZSAxLCBCYWQgaW50OCBleHRl
cm5hbCByZXByZXNlbnRhdGlvbiAiJzEyMyciDQoNCg0KDQooTXkgUG9zdGdy
ZVNRTCBpcyB2Ny4xKQ0KDQpJIHdvdWxkIGFwcHJlY2lhdGUgYW55IGhlbHAg
b3IgYWR2aWNlLg0KDQoNCg0KICAgICAgICB0aGFua3MgaW4gYWR2YW5jZSwN
Cg0KDQoNCiAgICBEb25nLCBNZW5nDQplZGR5QHNlY3VyaXRpZXMuY29tDQoN
Cg0K

Re: When dealing with 'bigint'or 'int8', the command 'copy'doesn't work

От
Tom Lane
Дата:
"Dong, Meng" <eddy@securities.com> writes:
> SGkgZ3V5cywNCg0KSSBtZWV0IGEgcHJvYmxlbSB3aGVuIHRyeSB0byBpbXBv
> cnQgZGF0YSBmcm9tIGEgVGFiLWRlbGltaXRlZC10ZXh0IGZpbGUgdG8gYSB0
> YWJsZSBieSBjb21tYW5kICdjb3B5IGZyb20nLiBBIHNhbXBsZSBwcm9jZWR1
> cmUgaXMgZXhwbGFpbmVkIGFzIGZvbGxvdywNCg0KDQpmaXJzdCwgSSBnZW5l
> cmF0ZSBhIGZpbGUgY2FsbGVkICAvaG9tZS90ZW1wL3Rlc3QudHh0LCBsZXQn
> [ etc ]

Please don't send HTML mail to the lists.

Although I'm not having any luck quoting your mail, I can tell
you that copying int8 values works fine for me.  If the error
message is spelled exactly as you show it, it suggests that's
what's really in your data file is not

    123    456

but

    '123'    '456'

            regards, tom lane