On Fri, Oct 19, 2012 at 1:14 AM, Shams Khan <shams.khan22@gmail.com> wrote:
> Hi Experts,
>
> I am new to postgresql, just wanted to know more about user creation.
>
> I tried to create users using command [create user sam] without any option]
> what are the default rights given to the user?
>
> radius=> select * from pg_user;
> usename | usesysid | usecreatedb | usesuper | usecatupd | userepl |
> passwd | valuntil | useconfig
> ----------+----------+-------------+----------+-----------+---------+----------+----------+-----------
> postgres | 10 | t | t | t | t |
> ******** | |
> radius | 9479531 | f | t | t | t |
> ******** | |
> sam | 9492031 | f | f | f | f |
> ******** | |
>
> what doest 't' and 'f' denotes here?? just want to clarify...
They're bool fields, so t and f denote true or false. I.e. a new user
with no flags set during creation gets all of those false.