insert bash-variables in psql-command

Question

I'm going crazy while trying to insert bash-variables in a psql commands as connection paramters as well as variables in the command itself. The following example works properly:

psql -U postgres -h localhost -p 5432 -c "CREATE DATABASE  testdb WITH ENCODING='UTF8' OWNER=postgres TABLESPACE=pg_default TEMPLATE=template_postgis CONNECTION LIMIT=-1;"

Now I'm trying to exchange each parameter through a variable, which is held in special config-file.

Non-working example:

dbserver=localhost
dbport=5432
dbowner=postgres
dbname=testdb
dbtemplate=template_postgis
dbtablespace=pg_default

 psql -U '$dbowner' -h '$dbserver' -p '$dbport' -c "CREATE DATABASE  '$dbname' WITH ENCODING='UTF8' OWNER='§dbowner' TABLESPACE='$dbtablespace' TEMPLATE='$dbtemplate'
CONNECTION LIMIT=-1;"

I've tried several quotings, backquotes and escape-slashes already but smhow it still won't work. Thanks in advance, knutella

And the error you get is...

Szymon Lipiński
– Szymon Lipiński

2013-05-14 11:44:18 +00:00
Commented May 14, 2013 at 11:44 — Szymon Lipiński
– Szymon Lipiński, Commented May 14, 2013 at 11:44

Grzegorz Żur · Accepted Answer · 2013-05-14 11:47:06Z

3

Use double quotes ("). Single quotes (') does not interpret shell variables inside.

Try it

 echo '$USER' "$USER"

See man bash.

answered May 14, 2013 at 11:47

Grzegorz Żur

49.5k17 gold badges121 silver badges112 bronze badges

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

1 Comment

knutella Over a year ago

Thanks, this also this works fine for me now. As I wrote in above's comments: ...my variables were sourced in incorrectly and empty..

Szymon Lipiński · Accepted Answer · 2013-05-14 11:49:19Z

3

This works... most of the quotes are not needed:

 psql -U $dbowner -h $dbserver -p $dbport -c "CREATE DATABASE  $dbname WITH ENCODING='UTF8' OWNER=$dbowner TABLESPACE=$dbtablespace TEMPLATE=$dbtemplate CONNECTION LIMIT=-1;"

answered May 14, 2013 at 11:49

Szymon Lipiński

28.8k17 gold badges81 silver badges82 bronze badges

1 Comment

knutella Over a year ago

Thanks this does the trick now. actually i tried it in the very first already, but problem was, that paramters are smhow where not proberly sourced in from config-file.

Collectives™ on Stack Overflow

insert bash-variables in psql-command

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related