| Lists: | Postg토토 결과SQL : Postg토토 결과SQL 메일 링리스트 : 2005-10-24 이후 PGSQL-Chat 23:47 |
|---|
| From: | "Sawant, Nandu" <nandakumar(dot)sawant(at)mitretek(dot)org> |
|---|---|
| To: | <pgsql-chat(at)postgresql(dot)org> |
| Subject: | Help for converting Oracle Script |
| Date: | 2005-10-24 19:33:12 |
| Message-ID: | 2E314DE03538984BA5634F12115B3A4E5C1646@email1.mitretek.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-chat |
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.
| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | pgsql-chat(at)postgresql(dot)org |
| Cc: | "Sawant, Nandu" <nandakumar(dot)sawant(at)mitretek(dot)org> |
| Subject: | Re: Help for converting Oracle Script |
| Date: | 2005-10-24 23:47:07 |
| Message-ID: | 200510241947.07461.xzilla@users.sourceforge.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg토토 결과SQL : Postg토토 결과SQL 메일 링리스트 : 2005-10-24 이후 PGSQL-Chat 23:47 |
On Monday 24 October 2005 15:33, Sawant, Nandu wrote:
> 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.
I don't think there is a natural equivilant for that in PostgreSQL. More to
the point though, this mailing list is no longer active, so if you want real
help, try posting to pgsql-general.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL