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 e66GFlW43359 for ; Thu, 6 Jul 2000 12:15:47 -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 NAA13351; Thu, 6 Jul 2000 13:27:49 -0300 Message-ID: <013c01bfe765$8304b460$5911be86@cte.Dal.Ca> From: "DalTech - Continuing Technical Education" To: "Margarita Barvinok" Cc: References: Subject: Re: Running queries from scripts. Date: Thu, 6 Jul 2000 13:16:16 -0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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/62 > It works for me, for example, this way: > athens% psql -d template1 -c "select datname from pg_database" Thanks, I feel a little sheepish at not trying it with quotes around the query, but the manuals don't mention that you have to enclose the query in quotes when you use the -c option. -Christopher Currie