I am very new to PostgreSQL database, I am developing database objects in SQL Server 2008 but I require some operation on PostgreSQL also.
Here, I write one sample stored procedure of SQL Server which I need to convert into PostgreSQL. Please help me in this with PostgreSQL.
Thanks in advance.
Below is sample SQL Server stored procedure: require to convert into PostgreSQL stored procedure
CREATE PROCEDURE [dbo].[usp_GetData_ByTableName]
(
@TableName NVARCHAR(MAX)
,@IncludeKeepAlive BIT
,@RowsAffected BIGINT=0 OUTPUT
) AS
BEGIN
SET NOCOUNT ON
DECLARE @SQL VARCHAR(MAX)
/****************************************************************
Select data base on parameter.
*****************************************************************/
SET @SQL =
'
SELECT *FROM '+@TableName+'
WHERE 1=1
'
+
CASE WHEN (@IncludeKeepAlive = 0)
THEN
'
AND [MessageTransactionID] <> 152
'
ELSE
''
END
EXECUTE SP_EXECUTESQL @SQL
RETURN 0
END