Michael Meskes <meskes(at)postgreSQL(dot)org> writes:
> On Tue, Jan 04, 2000 at 01:12:58PM -0500, Tom Lane wrote:
>> When generating quoted strings for use in SQL commands, you should
>> prefix single-quote (') and backslash (\) characters with a backslash.
> Isn't the correct way to quote a single-quote with yet another single-quote?
Yeah, doubled '' works too (but only in SQL literals, not in COPY data).
Take your pick...
regards, tom lane