Re: [HACKERS] Useful addition for psql?

Marc G. Fournier wrote:
>
> On Fri, 20 Jun 1997, Vadim B. Mikheev wrote:
>
> > > in the users directory.  When createdb is run, have a 'system default'
> > > profile written to that databases pg_profile?  Or would each table created
> >                      ^^^^
> > Why not in .../data dirrectory ? User may connect to different databases...
>
>         Would a user necessariloy want the same settings for all databases they
> access?

pg_profile in /data:

    usesysid    int4
    database    oid
        ^^^^^^^^^^^^^^^^^^^ - if this oid is invalid that these
                  settings are global (to be processed
                  first)
    settings    text

> for all tables?
  ^^^^^^^^^^^^^^
  Currently, all our settings affect session at whole...
I haven't idea about usefull table-level settings.

>
> > ...But - it requires dump/reload...
> > .pgsqlrc doesn't...
>
>         True...add .pgsqlrc, if possible, in time for Bruce's desire for
> a quick *one time only* v6.1 mega patch, and then throw in the pg_profile
> table right after?

Yes.

Vadim

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