From: | Ewald Geschwinde <webmaster(at)geschwinde(dot)net> |
---|---|
To: | "Molenda, Mark P" <mark(dot)molenda(at)eds(dot)com> |
Cc: | "Pgsql-Novice (E-mail)" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: running from a script |
Date: | 2002-06-27 16:07:17 |
Message-ID: | 3D1B3835.6090606@geschwinde.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Molenda, Mark P wrote:
>Thanks Ewald!
>
>I was wondering if you needed any special syntax for the sqlfile or you can
>just do the standard
>select * from tablename\g on a line. -Mark
>
>
it's an ascii file
select * from tablename;
Select x,y,z from tablename2;
Ewald
>-----Original Message-----
>From: Ewald Geschwinde [mailto:webmaster(at)geschwinde(dot)net]
>Sent: Thursday, June 27, 2002 10:41 AM
>To: Molenda, Mark P
>Cc: Pgsql-Novice (E-mail)
>Subject: Re: [NOVICE] running from a script
>
>
>Molenda, Mark P wrote:
>
>
>
>>I've read through most of Bruce Momjian's book on PostgresSQL and I have
>>
>>
>not
>
>
>>seen anything that shows how to run SQL commands from a script. I'm trying
>>to emulate some of the work I've done with Oracle in the past where I was
>>able to write either a DEC DCL script or a UNIX shell script to run SQL
>>commands
>>out of cron or another scheduler. Any help of snipits on how to get
>>
>>
>started
>
>
>>would be appreciated. -Mark
>>
>>Mark P. Molenda <<...OLE_Obj...>>
>>Senior Information Specialist
>>NYSC
>>
>>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>>
>>
>>
>>
>>
>>
>>
>psql -d database -U user < sqlfile
>
>Is that what you mean ?
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tony Griffiths | 2002-06-27 16:26:00 | Accessing geometric values from embedded SQL |
Previous Message | Ron Johnson | 2002-06-27 14:54:43 | Re: running from a script |