How can I automate running an init script when invoking a postgres DB using psql?

Question

psql (9.6.7, server 9.5.2) on linux

I have an init script... ~/sql.ini that I always want to run after connecting to a PG DB. I can do this by typing "\i ~/sql.ini", but is there a way to do this on the command line (which I alias) ?

pensnarik · Accepted Answer · 2020-03-04 16:26:25Z

1

Just put your commands in ~/.psqlrc file.

answered Mar 4, 2020 at 16:26

pensnarik

1,2723 gold badges12 silver badges16 bronze badges

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

1 Comment

daveg Over a year ago

That did it. Thanks pensnarik !

Laurenz Albe · Accepted Answer · 2020-03-04 16:22:50Z

0

Your alias should call

PSQLRC=~/sql.ini psql

That environment variable specifies the startup file that psql executes automatically.

answered Mar 4, 2020 at 16:22

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Collectives™ on Stack Overflow

How can I automate running an init script when invoking a postgres DB using psql?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related