On Wed, 2005-10-12 at 09:09 +0100, Oliver Elphick wrote: > Pg 8.0.3 (Debian package) on AMD64, linux 2.6.12 > > I am importing a table using COPY. The data is tab-delimited. COPY > seems to be putting the data for one field into the preceding field, > which should contain the empty string.
To follow up on this, there seems to be a general problem that COPY did not use the same column order as a default display for this particular table. The table had just been created and had not been subjected to alterations. I got round the problem by specifying the column list to the COPY command. -- Oliver Elphick olly@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA ======================================== Do you want to know God? http://www.lfix.co.uk/knowing_god.html ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
