escape single quote in INSERT command

From: dave_h4(at)yahoo(dot)com (Hunter)
To: pgsql-general(at)postgresql(dot)org
Subject: escape single quote in INSERT command
Date: 2002-11-22 13:00:31
Message-ID: 27ad91d2.0211220500.7d0a82f0@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Group -

I have a perl application for a registration form. I'd like to put
escape characters in my insert command to accommodate for '
(i.e. O'Brien, O'Malley, etc). I've tired double quotes, single
quotes, back tick, forward ticks, curly bracket, round brackets - no
success.

Thanks, dave

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2002-11-22 13:51:16 View and primary key
Previous Message Oliver Elphick 2002-11-22 11:58:39 Re: how do i find out when a record was created/modified?