Re: [OT] Re: installing tutos2

[csanyipal <csanyipal@csanyi-pal.info>]

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.
> > 
> > csanyipal@csanyi-pal:~$ su
> > Password: 
> > csanyi-pal:/home/csanyipal# su - postgres
> > postgres@csanyi-pal:~$ SELECT * FROM pg_user;
> > -su: SELECT: command not found
> > 
> After 'su - postgres', do this:
> 
> postgres@csanyi-pal:~$ 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