root>su pgsql pgsql>/usr/local/pgsql/bin/psql users_db Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit users_db=# SELECT uin,pass,nick,frst,last,email1 FROM register_requests; uin | pass | nick | frst | last | email1 ---------+--------+-------+------------------+------------+------------------- 98004698 | 42193F | john | Семен Гаврилович | Вертолетов | s_vert@mail.khstu.ru 98004699 | 237E24 | AlexX | Алексей Иванович | Пупкин | pupkin@mail.ru (2 rows) users_db=# UPDATE register_requests SET uin=100001 WHERE uin=98004699; UPDATE 1 users_db=# SELECT uin,pass,nick,frst,last,email1 FROM register_requests; uin | pass | nick | frst | last | email1 ---------+--------+-------+------------------+------------+------------------- 98004698 | 42193F | john | Семен Гаврилович | Вертолетов | s_vert@mail.khstu.ru 100001 | 237E24 | AlexX | Алексей Иванович | Пупкин | pupkin@mail.ru (2 rows) users_db=# INSERT INTO Users_Info_Ext (SELECT * FROM register_requests WHERE uin=100001); INSERT 1231098 1 users_db=# SELECT * FROM Users WHERE uin=100001; uin | frst | last | bcst | pass --------+--------------------+--------+------+-------- 100001 | Алексей Валерьевич | Брюква | 0 | 237E24 (1 row) users_db=# DELETE FROM register_requests WHERE uin=100001; DELETE 1 users_db=# \q pgsql>exit root>