Thread: Re: [INTERFACES] escaping characters ...
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. > I think that's all. Isn't the correct way to quote a single-quote with yet another single-quote? Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael@Fam-Meskes.De | Use PostgreSQL!
Michael Meskes <meskes@postgreSQL.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