Execute Query in Postgres Function - Mailing list pgsql-sql

From Sumita Biswas (sbiswas)
Subject Execute Query in Postgres Function
Date
Msg-id 003901c3faeb$c7d1cd60$2a154d0a@apac.cisco.com
Whole thread Raw
In response to Re: Postgres DB  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
How do we execute a Query String in Postgresql function?
Or what is the equivalent of the following Code in MSSQL Stored
Procedure:

SET @QueryToPopulateTemp = "INSERT INTO
#Tmp_ConferenceDetail(ConferenceType, ConnectTime,
DisconnectTime,DestConversationId, Duration, AppConfId, OrigDeviceName,
DestDeviceName, destLegIdentifier) " + 
"SELECT  * FROM Tbl_Billing_Data ";        

EXEC sp_executesql @QueryToPopulateTemp;


Thanks for any inputs.

Regards,
Sumita



pgsql-sql by date:

Previous
From: "Greg Patnude"
Date:
Subject: Re: User defined types -- Social Security number...
Next
From:
Date:
Subject: plpgsql function returning SETOF RECORD Question