On Mon, Mar 5, 2018 at 5:55 AM, Łukasz Jarych <jaryszek(at)gmail(dot)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.