[SQL] Unwanted nested dollar-quoted constants

2005-08-26 Thread Bernard Henry Voynet
Hello, I recurrently need to migrate a big amount of data from one database type to PostgreSQL 8.0.3. For this, I use INSERT scripts that I run from the pgAdmin III. All the text fields are specified using the dollar-quoted string constant form that. However, sometime, there are records that i

Re: [SQL] Unwanted nested dollar-quoted constants

2005-08-27 Thread Tom Lane
Bernard Henry Voynet <[EMAIL PROTECTED]> writes: > All the text fields are specified using the dollar-quoted string constant > form that. This is your mistake to start with. You can not simply stick a couple of dollar signs around a random string and expect to have a valid literal, any more than