Hello,
I have following Oracle script and trying to convert it for Postgres syntax:
= = = = = = = = = = = = = = =
prompt Enter value for monyy (Month Year; Ex-mar02 indicating March 2002)
define MONYY = &monyy
spool create_new_lerg_&MONYY._accounts.lst
prompt create user acc_&MONYY.
create user acc_&MONYY.
identified by lerg
temporary tablespace temp
default tablespace prices
quota unlimited on prices;
grant normal to acc_&MONYY.;
= = = = = = = = = = = = = = =
If I enter mar02 as a input for the defined variable MONYY, then it creates the ACC_MAR02 user in the database. Is there any equivalent for “define” statement in Postgres? Your help is appreciated.
Thanks,
Nandu.