Re: [ADMIN] How to create a superuser ?

Matthieu Verove writes: > When we enter: > > > create user dba1 createdb createuser; > > and after: > > select * from pg_user; > > the result is : > > > usename |usesysid|usecreatedb|usetrace|usesuper|usecatupd|passwd|valuntil > > --+--++-+---+--+--+-- >

Re: [ADMIN] Case insensitive

> select * from userdata wher name = 'John' > > select * from userdata wher name = 'joHN' > > will fetch me the same results. select * from userdata where lower(name) = 'john' -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://