Trouble With Strings - Mailing list pgsql-general

From Colin Taylor
Subject Trouble With Strings
Date
Msg-id 4B045DC53446D111A6CD00A0C949AB735E782A@TOBY
Whole thread Raw
List pgsql-general
Hi,
I have been having a few problems with strings (varchar)s.
How can I insert a quote ' character in a string?
The following, needless to say does not work:

    INSERT INTO table (string) VALUES ('colin's');

Also, are there any other characters that need special attention in order to
put them into the table?
And how can I handle them?
Thanks,
Colin


pgsql-general by date:

Previous
From: "Poul L. Christiansen"
Date:
Subject: Re: Re: What is the size of DB in Postgresql??
Next
From: George Armhold
Date:
Subject: Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux)