Re: help me plz with 2 postgres users

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?