How to pass a bash variable into an sql file

Question

I have a bash script to call a select in postgres. I would like to be able to pass a variable from the command line into the sql file.

sh myscript.sh 1234

#!/bin/bash
dbase_connect="psql -h server -U username dbase"
file="/tmp/$fname.csv"
sql="/home/user/sql_files/query.sql"

sudo bash -c "$dbase_connect -c -q -A -F , -f $sql -o $file"

The query can be as simple as:

select name from table where id = $1;

But I don't know how to call the $1 into the sql file. The actual query is much larger and I prefer to keep it out of the bash query itself because it is easier to maintain when called as a seperate .sql file.

Farvardin · Accepted Answer · 2014-03-05 17:54:09Z

3

you can use sed to insert parameter :

#!/bin/bash
dbase_connect="psql -h server -U username dbase"
file="/tmp/$fname.csv"
sql="/home/user/sql_files/query.sql"
tmp="home/user/sql_files/query.sql.tmp"
s="s/\$1/$1/g"
cat $sql | sed $s > $tmp

sudo bash -c "$dbase_connect -c -q -A -F , -f $tmp -o $file"
rm -f $tmp

answered Mar 5, 2014 at 17:54

Farvardin

5,4226 gold badges36 silver badges54 bronze badges

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

1 Comment

Matthew Over a year ago

Thanks! Works perfectly and gave me an idea to consolidate another script (less maintenance later).

Collectives™ on Stack Overflow

How to pass a bash variable into an sql file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related