Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1aiNwQ-0001KH-9d for pgsql-admin@arkaria.postgresql.org; Tue, 22 Mar 2016 15:09:54 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1aiNwP-0005tf-SH for pgsql-admin@arkaria.postgresql.org; Tue, 22 Mar 2016 15:09:53 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1aiNuh-00011G-9O for pgsql-admin@postgresql.org; Tue, 22 Mar 2016 15:08:07 +0000 Received: from barracuda.supercp.com ([216.234.124.52]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1aiNue-0004ol-Dg for pgsql-admin@postgresql.org; Tue, 22 Mar 2016 15:08:06 +0000 X-ASG-Debug-ID: 1458659282-089ef762fcf4370001-ysJW5H Received: from a2s36.a2hosting.com (a2s36.a2hosting.com [216.119.134.130]) by barracuda.supercp.com with ESMTP id qsJeeZtrv2vEFQkz for ; Tue, 22 Mar 2016 11:08:02 -0400 (EDT) X-Barracuda-Envelope-From: desoi@pgedit.com X-Barracuda-Apparent-Source-IP: 216.119.134.130 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=pgedit.com; s=default; h=To:References:Message-Id:Content-Transfer-Encoding:Cc:Date: In-Reply-To:From:Subject:Mime-Version:Content-Type; bh=342uujqhkC6KhRvbUaS7MoV/vW7slq1JfANJ72WbVdw=; b=Zon7WnffbnGRQm2P6gsa98xNy4 tiEbE6IMIuqO3d3ljbXgWMXhwxsLSc8tCnysMBvv+Q4nCvQmaecBZck9vzlWcPotcaX1fUWJMFPsS 2HOpBtS0NMPIjU4g6ESnUnUSVlKgub9n5ug/zZMs6QXe1L7oLrgBDq/3CyaKum9pcfXo=; Received: from 99-51-191-137.lightspeed.austtx.sbcglobal.net ([99.51.191.137]:37141 helo=[10.0.0.22]) by a2s36.a2hosting.com with esmtpsa (TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.86_1) (envelope-from ) id 1aiNuP-000Qws-O2; Tue, 22 Mar 2016 11:07:51 -0400 Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2104\)) Subject: Re: Passing parameters From: John DeSoi X-ASG-Orig-Subj: Re: [ADMIN] Passing parameters In-Reply-To: <2BC18916DE4BF141AC1EFC55CE2CAE7D1BBB644F@NAEANRFKXM01V.nadsusea.nads.navy.mil> Date: Tue, 22 Mar 2016 10:07:21 -0500 Cc: "pgsql-admin@postgresql.org" Content-Transfer-Encoding: quoted-printable Message-Id: <71A20608-90F0-4CB1-8910-9A08CBDCF421@pgedit.com> References: <2BC18916DE4BF141AC1EFC55CE2CAE7D1BBB644F@NAEANRFKXM01V.nadsusea.nads.navy.mil> To: "Ferrell, Denise D CTR NSWCDD, H11" X-Mailer: Apple Mail (2.2104) X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - a2s36.a2hosting.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - pgedit.com X-Get-Message-Sender-Via: a2s36.a2hosting.com: authenticated_id: desoi@pgedit.com X-Authenticated-Sender: a2s36.a2hosting.com: desoi@pgedit.com X-Barracuda-Connect: a2s36.a2hosting.com[216.119.134.130] X-Barracuda-Start-Time: 1458659282 X-Barracuda-URL: https://barracuda.supercp.com:443/cgi-mod/mark.cgi X-Virus-Scanned: by bsmtpd at supercp.com X-Barracuda-BRTS-Status: 1 X-Barracuda-Spam-Score: 0.00 X-Barracuda-Spam-Status: No, SCORE=0.00 using per-user scores of TAG_LEVEL=1000.0 QUARANTINE_LEVEL=4.0 KILL_LEVEL=5.0 tests=BSF_SC0_MISMATCH_TO X-Barracuda-Spam-Report: Code version 3.2, rules version 3.2.3.28053 Rule breakdown below pts rule name description ---- ---------------------- -------------------------------------------------- 0.00 BSF_SC0_MISMATCH_TO Envelope rcpt doesn't match header X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org > On Mar 22, 2016, at 9:44 AM, Ferrell, Denise D CTR NSWCDD, H11 wrote: >=20 > I've got a script that I'm running from the Linux command prompt that I n= eed to pass 2 parameter's into the psql script without using the VI Editor.= Is there an easy way to accomplish this? >=20 > psql -f -l See the psql command line variable options (-v, --set, --variable). http://www.postgresql.org/docs/9.5/static/app-psql.html#APP-PSQL-VARIABLES John DeSoi, Ph.D. --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin