Received: from mta3-rme.xtra.co.nz (mta3-rme.xtra.co.nz [203.96.92.13]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0V1L4q73159 for ; Tue, 30 Jan 2001 20:21:05 -0500 (EST) (envelope-from csawtell@xtra.co.nz) Received: from berty ([210.55.86.3]) by mta3-rme.xtra.co.nz with SMTP id <20010131012101.HJYI12118861.mta3-rme.xtra.co.nz@berty>; Wed, 31 Jan 2001 14:21:01 +1300 Content-Type: text/plain; charset="iso-8859-1" From: Christopher Sawtell Organization: At Home To: jkakar@expressus.com, pgsql-sql@postgresql.org Subject: Re: Automated scripting... Date: Wed, 31 Jan 2001 13:58:46 +1300 X-Mailer: KMail [version 1.2] References: <20010130155453.A29901@expressus.com> In-Reply-To: <20010130155453.A29901@expressus.com> MIME-Version: 1.0 Message-Id: <01013113584600.03563@berty> Content-Transfer-Encoding: 8bit X-Archive-Number: 200101/463 X-Sequence-Number: 1139 On Wed, 31 Jan 2001 12:54, jkakar@expressus.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 <<--