Re: Temporary tables and miscellaneous schemas

> > Um, I forget whether or not this was given any credence or anyone
> > weighed in on it, but what about having two modes for psql?  An
> > admin mode which hides nothing and is the default for superuser
> > connections, and a user mode which is the default for non-DBA
> > connections.
>
> I thought that would be likely to create more confusion than it
> solves.
>
> To take just one problem, the newbies who could use the "friendly
> user" mode are very likely the same ones who do all their work as
> postgres, because it hasn't occurred to them to create any
> unprivileged users.  They won't get the benefit of it if we make it
> act as you suggest.

Hrm, well, two flaws with that argument being:

1) Users who (ab)use DBA accounts aren't likely the ones with
   gazillions of pg_temp_* tables and probably don't even make use of
   temp tables or care about pg_toast.  No harm, no foul, as the
   feature isn't likely used.

2) Queries that are written by a DBA and given to a user will still
   work when executed by the user, so the confusion is limited to a
   \command not showing the same results that a DBA sees.

Seeing extra info if your prompt is '#' and not '%' shouldn't surprise
anyone.  Few complain about tab completion in shells not listing
programs that aren't readable by the current user.

eg:

    % /usr/local/bin/root_only_cmd[TAB]
    *system beeps, root_only_cmd_here isn't executable by $USER*
    # /usr/local/bin/root_only_cmd[TAB]
    # /usr/local/bin/root_only_cmd_here


-sc

--
Sean Chittenden