[EMAIL PROTECTED] 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?
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
