On Mon, Mar 5, 2018 at 5:55 AM, Łukasz Jarych <jarys...@gmail.com> wrote:
> Hi Guys, > > do you have also problem that every time you have to log into your > database using shell and psql? > > I have to write over and over localhost, username, password...how to force > shell to remember this? > > Use a service file. psql "service=mydb" -c "SELECT 1;" https://www.postgresql.org/docs/10/static/libpq-pgservice.html I also, for scripts, simply define a function at the top of the script psql_* and invoke that function instead of psql directly. I use .pgpass for passwords David J.
