| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christoph Della Valle | 2006-07-17 10:13:27 | Re: RE : How do I compile/test a PL/SQL in Postgresql |
| Previous Message | Tom Lane | 2006-07-14 19:15:51 | Re: PQexecParams and PQexecPreparaed |