Skip site navigation (1) Skip section navigation (2)

Re: Help for converting Oracle Script

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 (view raw or flat)
Thread:
Lists: pgsql-chat
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

In response to

pgsql-chat by date

Next:From: Anjan Kumar. A.Date: 2005-12-11 10:45:26
Subject: Please Help: PostgreSQL Query Optimizer
Previous:From: Sawant, NanduDate: 2005-10-24 19:33:12
Subject: Help for converting Oracle Script

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group