Re: [GENERAL] any way to query for current connections to db?

select * from pg_stat_activity where datname = ( select * from current_database() ); Original Message Subject: [GENERAL] any way to query for current connections to db? From: "Coarr, Matt" <[EMAIL PROTECTED]> Date: Fri, November 09, 2007 5:36 pm To: Hi, Is there any

Re: [GENERAL] query help

can u refer to row?? howto select * from table where row(#2) like 'J%'?? i wanted to test column storing but not ok as no row refer name/id. many thank yous sincerely siva Original Message Subject: Re: [GENERAL] query help From: [EMAIL PROTECTED] Date: Thu, September 13, 2007 11:

Re: [GENERAL] query help

many apologees. right link http://archives.postgresql.org/pgsql-general/2007-09/msg00607.php i flip row to column if ok. but howto query?? sincerely siva Original Message Subject: Re: [GENERAL] query help From: "Alexander Staubo" <[EMAIL PROTECTED]> Date: Thu, September 13, 2007

Re: [GENERAL] query help

hello i add more column not row for new user. i want all "last like 'J%'". http://www.nabble.com/an-other-provokative-question---tf4394285.html sincerely siva Original Message Subject: Re: [GENERAL] query help From: "Alexander Staubo" <[EMAIL PROTECTED]> Date: Thu, September 13,

[GENERAL] query help

hello table is +---+---+--+---+ | id | one | two | three | +---+---+--+---+ | first | Jack | Jill | Mary | | last | Ja | Ji | Ma | +---+---+--+---+ result is ++---+---+ | id | one | two | ++---+---+ | first

Re: [GENERAL] an other provokative question??

howto check column than row?? create table horizontal (id integer, first varchar(8), last varchar(8)); insert into horizontal values ('1', 'Jack', 'Ja'); insert into horizontal values ('2', 'Jill', 'Ji'); insert into horizontal values ('3', 'Mary', 'Ma'); select * from horizontal where true; +

[GENERAL] an other provokative question??

Relational database pioneer says technology is obsolete http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9034619 kindlt explain how?? sincerely siva ---(end of broadcast)--- TIP 4: Have you searched our list archiv

Re: [GENERAL] lo or bytea streaming engine??

bytea streaming engine is easy?? kindlt explain how?? how http://localhost:8080/database/table/bytea_column/id_column=value get data without select?? sincerely siva Original Message Subject: Re: [GENERAL] lo or bytea streaming engine?? From: Martijn van Oosterhout <[EMAIL PROTEC

[GENERAL] lo or bytea streaming engine??

helloany future for lo or bytea streaming engine with security like http://pbxt.blogspot.com/2007/06/geting-blob-out-of-database-with-blob.html many thank youssincerelysiva

[GENERAL] apt-get install postgresql.deb??

hello how to get postgresql 8* debian package?? nto at http://www.debian.org/distrib/packages http://www.postgresql.org/ftp/binary/v8.2.1/linux/?? many thank yous sincerely siva ---(end of broadcast)--- TIP 9: In versions below 8.0, the planne

Re: [GENERAL] Scalability

Top at 350-400 concurrent connections! Although more than my project's peak estimates, it is a bit discomforting. Are there any *promising* load testing numbers with Windows 2003? I'd be happy to share results from my simulations. Matt > Original Message > Subject: Re: [GENERAL]