[ADMIN] Select Command in Procedures

2011-02-03 Thread Adarsh Sharma
Dear all, I am able to execute command successfully through CLI or pgAdmin . *create table user_news_new as select record_id,field_name,field_value,news_date from user_news where field_name in ('SOI','RelLoc','Description','Heading','news_date') and field_value != '' ; * But I don't know wh

Re: [ADMIN] Select Command in Procedures

2011-02-03 Thread Christian Ullrich
* Adarsh Sharma wrote: I am able to execute command successfully through CLI or pgAdmin . *create table user_news_new as select record_id,field_name,field_value,news_date from user_news where field_name in ('SOI','RelLoc','Description','Heading','news_date') and field_value != '' ; * But I don

[ADMIN] Is there a batch/bulk UPDATE syntax available?

2011-02-03 Thread Gnanakumar
Hi, Is there a batch/bulk UPDATE query syntax available in PostgreSQL, similar to multirow VALUES syntax available for INSERT? INSERT Multirow VALUES syntax example: INSERT INTO films (code, title, did, date_prod, kind) VALUES ('B6717', 'Tampopo', 110, '1985-02-10', 'Comedy'), ('HG120', '

Re: [ADMIN] Is there a batch/bulk UPDATE syntax available?

2011-02-03 Thread Thomas Kellerer
Gnanakumar, 03.02.2011 13:00: Is there a batch/bulk UPDATE query syntax available in PostgreSQL, similar to multirow VALUES syntax available for INSERT? INSERT Multirow VALUES syntax example: INSERT INTO films (code, title, did, date_prod, kind) VALUES ('B6717', 'Tampopo', 110, '1985-02-10'

Re: [ADMIN] Is there a batch/bulk UPDATE syntax available?

2011-02-03 Thread pasman pasmański
Show us explain analyze for this update. 2011/2/3, Gnanakumar : > Hi, > > Is there a batch/bulk UPDATE query syntax available in PostgreSQL, similar > to multirow VALUES syntax available for INSERT? > > INSERT Multirow VALUES syntax example: > INSERT INTO films (code, title, did, date_prod, kind)

[ADMIN] maximum rows to retrive

2011-02-03 Thread Antonio Biondo
Hi, i not found in query tool of PgAdmin III the option to set "maximum rows to retrive". Is there no this option? -- Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it http://www.email.it/f Sponsor: Apri Conto Corrente Arancio entr

Re: [ADMIN] unexpected pageaddr

2011-02-03 Thread French, Martin
Have you tried connecting to the standby? If the standby is in progress, then it should refuse with a "Database Starting message" IIRC. If this is the case, I'd say it's fine... Until someone comes along and corrects me of course... Cheers -Original Message- From: pgsql-admin-ow...@pos

[ADMIN] PostgreSQL 9.0

2011-02-03 Thread Smith, Andy V
Hi We are looking to use PostgreSQL as a database for our development community and I would like to know if I can be guided to a list of packages and dependencies, which will allow me to install the product in a Red Hat Linux 5.5. environment. Thanks and regards, Andy V Smith CATE - Global Da

Re: [ADMIN] PostgreSQL 9.0

2011-02-03 Thread Devrim GÜNDÜZ
On Thu, 2011-02-03 at 13:10 +, Smith, Andy V wrote: > > > We are looking to use PostgreSQL as a database for our development > community and I would like to know if I can be guided to a list of > packages and dependencies, which will allow me to install the product > in a Red Hat Linux 5.5. e

Re: [ADMIN] maximum rows to retrive

2011-02-03 Thread Guillaume Lelarge
Le 01/02/2011 18:44, Antonio Biondo a écrit : > Hi, i not found in query tool of PgAdmin III the option to set "maximum > rows to retrive". Is there no this option? > This option only exists in the data grid. If you need this in the query editor, add a LIMIT clause on your queries. -- Guillaum