On Thu, Jan 04, 2007 at 12:16:17AM -0800, [EMAIL PROTECTED] wrote: > On Wed, Jan 03, 2007 at 10:31:46PM -0600, mike wrote: > > How are you attempting to restore the table after using psql? Psql > > insert statements? Pgdump? COPY FROM? > > Actually, right now I feed the dump file into a program which mangles > it and analyzes it in various ways. It will eventually be fed into > psql for restoration elsewhere. The problem isn't restoring it. It's > not knowing how to tell which tabs are field separators and which are > part of the data.
psql is prety dumb that way, being designed for people not programs. I think recent versions will escape the tab. I suggest you use \copy instead, which on recent versions will allow you to copy from a query. Alternativly, use a delimiter that doesn't exist in your data. Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
