Re: quotes in pl/pgsql - Mailing list pgsql-sql

From clayton cottingham
Subject Re: quotes in pl/pgsql
Date
Msg-id 3AA6C50B.2BCA7E52@smartt.com
Whole thread Raw
In response to quotes in pl/pgsql  (Najm Hashmi <najm@mondo-live.com>)
List pgsql-sql
Najm Hashmi wrote:
> 
> Hi all, I just want to know how to put quotes around a string. Is there a
> function to do so?
> If not how can I escape  a single quote.
> Thank you in advance.
> 
>   ------------------------------------------------------------------------
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

single qutoe escaping :

'here''s johnny'


pgsql-sql by date:

Previous
From: Kyle
Date:
Subject: A query that doesn't work on 7.1
Next
From: Tom Lane
Date:
Subject: Re: A query that doesn't work on 7.1