On Sat, May 26, 2007 at 06:07:32PM -0400, Roberto C. Sánchez wrote:
> > > Log in to postgres and execute this:
> > >
> > > SELECT * FROM pg_user;
> > >
> > > Paste the results.
> >
> > [EMAIL PROTECTED]:~$ su
> > Password:
> > csanyi-pal:/home/csanyipal# su - postgres
> > [EMAIL PROTECTED]:~$ SELECT * FROM pg_user;
> > -su: SELECT: command not found
> >
> After 'su - postgres', do this:
>
> [EMAIL PROTECTED]:~$ psql -d template1
>
> After that you get a psql prompt. That is where you execute the SELECT
> statement.
template1=# SELECT * FROM pg_user;
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd |
valuntil | useconfig
--------------+----------+-------------+----------+-----------+----------+----------+-----------
postgres | 1 | t | t | t | ******** |
|
phpgroupware | 2 | f | f | f | ******** |
|
csanyipal | 100 | f | f | f | ******** |
|
(3 sor)
(3 sor) that is (3 raw)
--
Regards, Paul Csányi
http://www.freewebs.com/csanyi-pal/index.htm
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
