> Hi,
>
> We are in the process of migrating of our application from Oracle to
> PostGreSQL.
>
>
> we are facing a few problems with PL/SQL Code..
>
> 1) Can we perform DML statements on VIEWS in PostGreSQL as we do in
> ORACLE?
> Do I need to create some RULES for that ??
>
> 2 In Oracle sqlplus we can run sql script files as @script_name;
> How do we do the same in PostGres.
> Also is there any replacement for "&&" in PostGres ?
>
>
> Eg:
> CREATE USER CATALOG
> IDENTIFIED BY &ORA_PASSWORD
> DEFAULT TABLESPACE &DFLT_TABLESPACE
> TEMPORARY TABLESPACE &TEMP_TABLESPACE
>
>
> Regards
>
> Jomon Skariah.
>