Received: from Alex2.cte.Dal.Ca (Alex2.cte.Dal.Ca [134.190.17.62]) by hub.org (8.10.1/8.10.1) with ESMTP id e66FnnW76210 for ; Thu, 6 Jul 2000 11:49:49 -0400 (EDT) Received: from ghost (Ghost.cte.Dal.Ca [134.190.17.89]) by Alex2.cte.Dal.Ca (8.9.3/8.9.3) with SMTP id NAA13124 for ; Thu, 6 Jul 2000 13:01:52 -0300 Message-ID: <011001bfe761$e57a3a60$5911be86@cte.Dal.Ca> From: "DalTech - Continuing Technical Education" To: Subject: Running queries from scripts. Date: Thu, 6 Jul 2000 12:50:23 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_010D_01BFE748.C00B70A0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200007/60 This is a multi-part message in MIME format. ------=_NextPart_000_010D_01BFE748.C00B70A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I was wondering if anyone could help me out with the syntax of running quer= ies from a unix script. psql -c select 'I am a dummy' -d dbname - never seems to work. I've tried= variations on the command line, but to no success. Does the -c option work? Cheers, Christopher Currie __________________________________ Dalhousie: DalTech - CTE Visit our Web site at http://www.cte.dal.ca (902) 494-6079 (800) 565-1179 ------=_NextPart_000_010D_01BFE748.C00B70A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I was wondering if anyone could help me out with the sy= ntax of=20 running queries from a unix script.
 
psql -c select 'I am a dummy' -d dbname  - never s= eems to=20 work.  I've tried variations on the command line, but to no=20 success.
 
Does the -c option work?
 
Cheers,
Christopher Currie

__________________________________
Dalhousie: Da= lTech -=20 CTE
Visit our Web site at http://www.cte.dal.ca
(902)=20 494-6079
(800) 565-1179
------=_NextPart_000_010D_01BFE748.C00B70A0--