Home > mailing lists

passing text value with single quote to stored procedure - Mailing list pgsql-general

From	Prabhjot Sheena
Subject	passing text value with single quote to stored procedure
Date	July 13, 2013 01:05:53
Msg-id	CAOf_bQYJ2JAym1wNQ3=iZdHNabawBGVUAfu-n9fGZAjJWg8BXA@mail.gmail.com Whole thread Raw
Responses	Re: passing text value with single quote to stored procedure (Adrian Klaver <adrian.klaver@gmail.com>) Re: passing text value with single quote to stored procedure (Alban Hertroys <haramrae@gmail.com>)
List	pgsql-general

Hi all

I am currently having an issue with passing a value with a single quote in it to stored procedure

i am trying to pass this text value QA_SUMMER ' 2013_(EU/US) to stored procedure text variable. it gives me error.

Here is more detail on this

My stored procedure is something like this

CREATE OR REPLACE FUNCTION load_stage_start_v1( p_name text)

when this value is passed to the function

select load_stage_start_v1('QA_SUMMER'2013_(EU/US)');

This gives an error. Is there a way to fix this issue.

And if i am sending this question to the wrong mailing list pls let me know.

Thanks in advance

From: ktewari1
Date: 13 July 2013, 00:37:24
Subject: Build RPM from Postgres Source

From: Adrian Klaver
Date: 13 July 2013, 03:11:43
Subject: Re: passing text value with single quote to stored procedure