Re: [HACKERS] Useful addition for psql?

On Fri, 20 Jun 1997, Martin J. Laubach wrote:

> > What about user profiles stored in database in system pg_profile
> > table ? We live in virtual world...
>
>   Yes, but I may need different .psqlrc for different databases.
> I'd say
>
>     - global rc file (maybe in a pg_profile table)
>     - user settings (~/.pgrc, or maybe in the database too?)
>     - extra user settings (./.pgrc, or specified on command line)

    Take a look at the gated.conf/named.conf files...they have it
setup so that you have {}'d configuration sections...

    Why not something that goes:

settings database1 {
    options here
}
settings database2 {
    option here
}
etc


    One config file, many directives...

    hell, while we are at it, why not go one step further and add an
option from that file to do the security on a per-database basis...oops,
nope, that would have to be in the pg_profile, where the owner could setup
'access privileges' like is in pg_hba.conf without having to bother the
superuser?

Marc G. Fournier                                 scrappy@hub.org
Systems Administrator @ hub.org              scrappy@freebsd.org

------------------------------