Hi..
In postgres, you have two options..
>From PSQL prompt, you can use " \i filename " to process the file..
OR from PSQL prompt, you can directly instruct to execute that file like..
psql ... --filename <>
Basically, when "&&" is specified in PL/SQL scripts, it prompts the user to
enter its v
On Wed, Aug 20, 2003 at 03:15:23PM +0530, Jomon Skariah wrote:
>
> we are facing a few problems with PL/SQL Code..
>
>
> 1)In Oracle sqlplus we can run sql script files as @script_name;
> How do we do the same in PostGres.
psql takes \i. See psql's \?
See the "Porting From Oracle PL
To: Jomon Skariah; [EMAIL PROTECTED]
Subject: Re: [SQL] Porting from PL/SQL to PLPGSQL
Jomon,
> 1)In Exceptions ORACLE have something called WHEN OTHERS THEN cluase.I
> can't find a replacement for that in
> PostGreSQL.
PL/pgSQL currently does not handle exceptions
> we are facing a few problems with PL/SQL Code..
>
> 1)In Exceptions ORACLE have something called WHEN OTHERS THEN cluase.I
> can't find a replacement for that in
> PostGreSQL.
What does it do?
> 2 Oracle have a function USERENV to get the user session
> informati
Jomon,
> 1)In Exceptions ORACLE have something called WHEN OTHERS THEN cluase.I
> can't find a replacement for that in
> PostGreSQL.
PL/pgSQL currently does not handle exceptions at all. This is on the TODO
list.
> 2 Oracle have a function USERENV to get the user session
>
