Re: Porting from PL/SQL to PLPGSQL
От | denis@coralindia.com |
---|---|
Тема | Re: Porting from PL/SQL to PLPGSQL |
Дата | |
Msg-id | 014701c36876$6f1ff1e0$0f32a8c0@denisnew обсуждение исходный текст |
Ответ на | Porting from PL/SQL to PLPGSQL (Jomon Skariah <jomons@aztec.soft.net>) |
Список | pgsql-sql |
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 <<your_file_name>> Basically, when "&&" is specified in PL/SQL scripts, it prompts the user to enter its value. In Postgres, we do not have such option (so far i know). So, you can replace those with your desired values directly. Postgres supports Array type too. Although i haven't used it anyday.. you can try it out. HTH Denis ----- Original Message ----- From: "Jomon Skariah" <jomons@aztec.soft.net> To: <pgsql-sql@postgresql.org> Sent: Wednesday, August 20, 2003 3:15 PM Subject: [SQL] Porting from PL/SQL to PLPGSQL > > Hi All, > > 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) 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 > > > 2) In PostGres a function can not take more 16 arguments.We have some > procedures which are taking more than > 16 arguements.So how can we convert them into PostGres. > > > > Can anyone give some valuable suggestions.. > > > Regards > > Joe. > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend
В списке pgsql-sql по дате отправления: