Re: Automated scripting...

From: Christopher Sawtell <csawtell(at)xtra(dot)co(dot)nz>
To: jkakar(at)expressus(dot)com, pgsql-sql(at)postgresql(dot)org
Subject: Re: Automated scripting...
Date: 2001-01-31 00:58:46
Message-ID: 01013113584600.03563@berty
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, 31 Jan 2001 12:54, jkakar(at)expressus(dot)com wrote:
> Hi,
>
> I'm building a script to create a relatively large database. At some
> point in the script I would like to be able to save values into
> variables so that I can use them to populate rows.
>
> Is this possible with SQL? My understanding is that it is not
> possible but thought I'd ask anyway.

I know it seems a bit messy, but you could always use a temporary table to
store the values.

--
Sincerely etc.,

NAME Christopher Sawtell
CELL PHONE 021 257 4451
ICQ UIN 45863470
EMAIL csawtell @ xtra . co . nz
CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz

-->> Please refrain from using HTML or WORD attachments in e-mails to me <<--

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Sawtell 2001-01-31 01:00:23 Re: binary operators
Previous Message Rick Delaney 2001-01-31 00:50:05 Permissions for foreign keys