Pass parameters to postgres sql script and provide default values if they are not provided

Question

I have a postgres sql script that has a create table statement. Before that it tries to connect to database using \c dbname inside same script. I want to pass this dbname as parameter to this sql script. If no parameter is passed it needs to assign a default value declared inside the script.

I see parameters can be passed to postgres sql script like eg: psql -v dbname = testdb -h localhost -U postgres -a -f create_table.sql

and variables can be declared inside postgres sql file using eg: dbname VARCHAR := "local_db"; but having trouble how to check if parameter is passed or not and assign default value if it is not passed.

Any idea how to achieve this?

Take a look at this one, it may help: stackoverflow.com/questions/32582600/… — ravioli
– ravioli, Commented Aug 27, 2019 at 6:26

Laurenz Albe · Accepted Answer · 2019-08-27 06:47:52Z

0

You can pass a variable to psql with

psql -v 'var=value'

In the script you can reference the variable as :var. There are also :'var' and :"var" to get quoted versions of the value.

answered Aug 27, 2019 at 6:47

Laurenz Albe

257k22 gold badges313 silver badges389 bronze badges

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

Collectives™ on Stack Overflow

Pass parameters to postgres sql script and provide default values if they are not provided

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related