Adding psql in shell script

Question

I have this code $(echo "psql -U postgres -d mydb -c "SELECT * FROM table_name;" " | ssh $REMOTE_IP)

I need to run that query in the remote host, but i can't apply the query part in the echo

Any help?

oliv · Accepted Answer · 2018-03-20 12:34:39Z

1

Your syntax is incorrect and you don't need to use pipe. Try this:

ssh "$REMOTE_IP" 'psql -U postgres -d mydb -c "SELECT *  FROM table_name;"'

answered Mar 20, 2018 at 12:34

oliv

13.3k30 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

@PedroOsório Glad to see it works. Please consider upvoting/accepting the answer.