Re: help me plz with 2 postgres users

[Rodriguez Fernando <rodriguez(at)ort(dot)edu(dot)uy>]

spol(at)mail(dot)ru wrote:
> Hello?
> help me plz? i don't khow what to do...
>
> How can I delete first postgres user.
>
> template1=# select usename,passwd,valuntil,ctid,xmin,xmax,cmin,cmax 
> from pg_shadow where usesysid=1;
> usename  |               passwd                | valuntil | ctid  | 
> xmin |   xmax   |   cmin   | cmax
> ----------+-------------------------------------+----------+-------+------+----------+----------+------ 
>
> postgres |                                     |          | (0,1) |    
> 1 | 16754522 | 16754522 |    0
> postgres | md65476547442532.. | infinity | (0,2) |    2 |        
> 0       |        0        |    0
> (2 rows)
>
> thx for your help.
> Oleg
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
Hola, no se me ocurre como ayudarte pero podrias hace asi la consulta:
select usename||'-',passwd,valuntil,ctid,xmin,xmax,cmin,cmax from 
pg_shadow where usesysid=1;

Que version de postgres estas usando?