Re: [SQL] pg_stat_activity return all connections

On Apr 28, 2009, at 8:43 AM, Emi Lu wrote: Good morning, A question about pg_stat_activity: If believe that "select * from pg_stat_activity where usename='db_user1'" returns all connections based on db_user1, no matter the connection is through terminal command or jdbc, am I right? Yes.

Re: [SQL] Storing null bytes in bytea

Hi Tom, Your example works fine in psql: regression=# create table t1 (f1 bytea); CREATE TABLE regression=# insert into t1 values (E'IsLoggedIn|b:1;CurrentUser|O:17:"Class_SystemUser":4:{s:26:"\\000Class_SystemUser}'::bytea); INSERT 0 1 regression=# select * from t1;

[SQL] pg_stat_activity return all connections

Good morning, A question about pg_stat_activity: If believe that "select * from pg_stat_activity where usename='db_user1'" returns all connections based on db_user1, no matter the connection is through terminal command or jdbc, am I right? Thank you, -- Lu Ying -- Sent via pgsql-sql mail