Re: psql in a bash function - Mailing list pgsql-general

From Eric Raskin
Subject Re: psql in a bash function
Date
Msg-id kcis.3D3AAD230F23449F9360E8A5907F5D92@mail.paslists.com
Whole thread Raw
In response to psql in a bash function  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
Yes, you need double quotes around $@, as in "$@".

https://www.gnu.org/software/bash/manual/html_node/Special-Parameters.html



Sent from my Verizon, Samsung Galaxy smartphone


-------- Original message --------
From: Ron Johnson <ron.l.johnson@cox.net>
Date: 3/12/18 2:15 PM (GMT-05:00)
To: pgsql-general <pgsql-general@postgresql.org>
Subject: psql in a bash function



Hi,

Because I need to log into many servers, I created functions as keyboard shortcuts (not aliases, since I will want to embed these shortcuts in other functions).

psqlxyz ()
{
    echo "P1=$1";
    echo "P2=$2";
    psql -U postgres -h XYZ $@
}

This is the (simple, test) command that I want to run, which works when run explicitly using psql, but not my function.  Any ideas why the function isn't properly passing the "-c" and '"select ..."' to psql?

$ psql -U postgres -h XYZ -c "select oid, datname from pg_database;"
   oid   |        datname       
---------+------------------------
       1 | template1
   11563 | template0
   11564 | postgres
   16404 | test1
 3039800 | ABCD
  319011 | EFGH
  649861 | IJKL
(7 rows)

$ psqldba -c '"select oid, datname from pg_database;"'
P1=-c
P2="select oid, datname from pg_database;"
psql: warning: extra command-line argument "datname" ignored
psql: warning: extra command-line argument "from" ignored
psql: warning: extra command-line argument "pg_database;"" ignored
psql: FATAL:  database "oid," does not exist

Thanks

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: psql in a bash function
Next
From: Steven Roth
Date:
Subject: UPSERT on a view