Thread: When dealing with 'bigint'or 'int8', the command 'copy'doesn't work
SGkgZ3V5cywNCg0KSSBtZWV0IGEgcHJvYmxlbSB3aGVuIHRyeSB0byBpbXBv cnQgZGF0YSBmcm9tIGEgVGFiLWRlbGltaXRlZC10ZXh0IGZpbGUgdG8gYSB0 YWJsZSBieSBjb21tYW5kICdjb3B5IGZyb20nLiBBIHNhbXBsZSBwcm9jZWR1 cmUgaXMgZXhwbGFpbmVkIGFzIGZvbGxvdywNCg0KDQpmaXJzdCwgSSBnZW5l cmF0ZSBhIGZpbGUgY2FsbGVkICAvaG9tZS90ZW1wL3Rlc3QudHh0LCBsZXQn cyBzdXBwb3NlIGl0IGhhcyBvbmx5IHR3byBsaW5lcywgKCB0aGUgZm91ciBm aWd1cmVzIGFyZSBkZWxpbWl0ZWQgYnkgdGFiKQ0KMTIzICAgICA0NTYNCjc4 OSAgICAgOTk5DQoNClNlY29uZCwgSSB0eXBlIHRoZSBmb2xsb3dpbmcgY29t bWFuZCB1bmRlciBQU1FMLA0KY3JlYXRlIHRhYmxlIHR0dCAoIGMxIGJpZ2lu dCwgYzIgYmlnaW50KTsNCg0KRmluYWxseSwgSSB0cnkgdG8gaW1wb3J0IHRo ZSBkYXRhIGZyb20gdGVzdC50eHQgaW50byB0YWJsZSB0dHQgYnksDQpjb3B5 IHR0dCBmcm9tICcvaG9tZS90ZW1wL3Rlc3QudHh0JzsNCg0KDQpCdXQgSSB3 YXMgdG9sZCwNCkVSUk9SOiAgY29weTogbGluZSAxLCBCYWQgaW50OCBleHRl cm5hbCByZXByZXNlbnRhdGlvbiAiJzEyMyciDQoNCg0KDQooTXkgUG9zdGdy ZVNRTCBpcyB2Ny4xKQ0KDQpJIHdvdWxkIGFwcHJlY2lhdGUgYW55IGhlbHAg b3IgYWR2aWNlLg0KDQoNCg0KICAgICAgICB0aGFua3MgaW4gYWR2YW5jZSwN Cg0KDQoNCiAgICBEb25nLCBNZW5nDQplZGR5QHNlY3VyaXRpZXMuY29tDQoN Cg0K
"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