Trouble With Strings

From: Colin Taylor <Colin_Taylor(at)PortaSystemsDev(dot)com>
To: "Pgsql Mailing List (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Trouble With Strings
Date: 2000-11-23 11:16:35
Message-ID: 4B045DC53446D111A6CD00A0C949AB735E782A@TOBY
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message George Armhold 2000-11-23 11:52:32 Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux)
Previous Message Ould 2000-11-23 10:45:05 Re: What is the size of DB in Postgresql??