copy command truncate data

#1

is it possible to have the copy command truncate character data when
the data is too long to fit in the field? For example field
description1 is 19 char long in table. But there is 20 char in the
load file.
Thanks
Paul

#2

begin pauls (AT) computer-systems (DOT) com schrieb:

Quote:

is it possible to have the copy command truncate character data when
the data is too long to fit in the field? For example field

As far as i know: no.

Quote:

description1 is 19 char long in table. But there is 20 char in the
load file.

Load the data in a temp. table with text instead char(19) and use
substring() or similar to INSERT the data from this table to the
destination.

end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

copy command truncate data

comp.databases.postgresql comp.databases.postgresql

copy command truncate data - 04-13-2007 , 10:22 AM

Re: copy command truncate data - 04-16-2007 , 01:37 AM