Re: sql-postgres connect using URL

[Rob Sargent]

On 10/27/22 23:25, Jean Louis wrote:
> * Rob Sargent <rsargent@xmission.com> [2022-10-28 07:48]:
> > This clearly works from the command line:
> >
> >     psql
> >     
> > postgresql://postgres@csgsdb/postgres?&keepalives_idle=60&keepalives_interval=30&keepalives_count=10
> I had no idea about it.
>
> > I do get connected to the database, at least.  I'll have to wait for the
> > time out to NOT happen :). Meanwhile I'm connecting with emacs in the usual
> > way, then once connected I issue a
> >
> >     \c host=hostname user=rolename keepalives_idle=60
> >     keepalives_interval=30 keepalives_count=10
> Then use variable sql-postgres-options to add extra arguments to
> psql.
>
> You can also use ~/.psqlrc to set things up.
But question becomes How to stop emacs from prompting for all the usual 
args (host, etc).


Null the alist of prompts I suppose.  Let me dig in.