Skip site navigation (1) Skip section navigation (2)

RE : How do I compile/test a PL/SQL in Postgresql

From: "Patrick Ng" <patrick(dot)ng(at)zuji(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: RE : How do I compile/test a PL/SQL in Postgresql
Date: 2006-07-17 09:28:36
Message-ID: 631AA2476DFFD047873427369B8C0698032A6371@teasgex1.teasin.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

 

I am a novice to PostgreSQL (although I know ORACLE's PL/SQL very well)

 

I have written a Stored Function in PostgreSQL but cannot figure out how
to compile it or run it in PostgreSQL. In ORACLE, one would have to 

do this at SQL*PLUS prompt : @<file-path\file_name to compile the stored
function into ORACLE DB. 

In PostgreSQL, how do I do that?

 

In ORACLE, one would have to write a PL/SQL to test the stored function
(and use DBMS_OUTPUT.PUT_LINE) to get the stored function to write to
stdout.

 

In PostgreSQL, how do I test the stored function? I noticed none of the
documentation or books seemed to mention this simple point.

 

Best regards

 

Responses

pgsql-novice by date

Next:From: Christoph Della ValleDate: 2006-07-17 10:13:27
Subject: Re: RE : How do I compile/test a PL/SQL in Postgresql
Previous:From: Tom LaneDate: 2006-07-14 19:15:51
Subject: Re: PQexecParams and PQexecPreparaed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group