Postgres: Run some hard-coded SQLs then drop to interactive terminal

Question

When you start interactive bash, it runs .bashrc first and then it gives you an interactive prompt. Very handy to setup bash in the right way.

I'm trying to do the same with Postgres client (psql). I want to set some session configuration parameters before I run SQL statements interactively. Does psql let me do that?

The -c option and the -f option are the standard ways to run a pre-canned SQL statements, but the man page clearly states that those options are incompatible with the interactive mode.

Amazing enough psql has a psqlrc file. See here psql under the section "Files" at bottom pf page. Or search for psqlrc in the page. — Adrian Klaver
– Adrian Klaver, Commented Aug 11, 2021 at 22:52

jjanes · Accepted Answer · 2021-08-11 22:52:35Z

2

The analogy to .bashrc extend to the name as well. You want .psqlrc

answered Aug 11, 2021 at 22:52

jjanes

44.9k5 gold badges39 silver badges48 bronze badges

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

Collectives™ on Stack Overflow

Postgres: Run some hard-coded SQLs then drop to interactive terminal

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related