suggestion/question pgpass alias?
is it possible to support an alias for a pgpassfile? what I'm looking to do is psql --alias company -h localhost and not type anything else and get a shell. if this is not possible could this be added? -- Caleb Cushing https://xenoterracide.com
suggestion: psql configs in .config
would it be possible to allow psql config files to reside in ~/.config/psql to help unclutter ~ obviously this should be some kind of cascading lookup first look for... e.g .config/psql/psqlrc .psqlrc or vice versa -- Caleb Cushing https://xenoterracide.com
Re: suggestion/question pgpass alias?
Thanks! On Thu, Jun 11, 2020 at 3:27 PM Alvaro Herrera wrote: > On 2020-Jun-11, Caleb Cushing wrote: > > > is it possible to support an alias for a pgpassfile? what I'm looking to > do > > is > > > > psql --alias company -h localhost > > > > and not type anything else and get a shell. if this is not possible > could > > this be added? > > I think what you want is a "service" file. See > https://www.postgresql.org/docs/current/libpq-pgservice.html > > -- > Álvaro Herrerahttps://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services > -- Caleb Cushing https://xenoterracide.com
Re: suggestion: psql configs in .config
Got it. but... I guess I'm hoping this could be added to the default lookup path, no customization needed. On Thu, Jun 11, 2020 at 3:33 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thursday, June 11, 2020, Caleb Cushing wrote: > >> would it be possible to allow psql config files to reside in >> ~/.config/psql to help unclutter ~ obviously this should be some kind of >> cascading lookup >> >> first look for... e.g >> .config/psql/psqlrc >> .psqlrC >> > > libpq consults environment variables to allow for user customization. > > David J. > > -- Caleb Cushing https://xenoterracide.com
