Skip site navigation (1)
Skip section navigation (2)
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
Peripheral Links
Header And Logo
|
Site Navigation
generating UPDATE SET ... WHERE PK = ...
- From: Laurent ROCHE <laurent_roche(at)yahoo(dot)com>
- To: PGAdmin Support <pggadmin-support(at)postgresql(dot)org>, pgsql-general(at)postgresql(dot)org
- Subject: generating UPDATE SET ... WHERE PK = ...
- Date: Tue, 30 Oct 2007 17:00:13 -0700 (PDT)
Hi,
I would like to generate with a request a SQL order like
UPDATE tab1
SET col_a = ?, col_b = ? ...
WHERE pk = ?
for each table of a given schema (in fact what I want is slightly more complicated but if I can write the above, I will be able to get the rest).
Will anyone be kind enough to share a piece of code doing this (from pgAdmin may be) ?
Cheers,
L(at)u
The Computing Froggy
I would like to generate with a request a SQL order like
UPDATE tab1
SET col_a = ?, col_b = ? ...
WHERE pk = ?
for each table of a given schema (in fact what I want is slightly more complicated but if I can write the above, I will be able to get the rest).
Will anyone be kind enough to share a piece of code doing this (from pgAdmin may be) ?
Cheers,
L(at)u
The Computing Froggy
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
- Prev by Date: Re: PostgreSQL and AutoCad
- Next by Date: Re: Delete/Update with order by
- Previous by thread: Updated .vim file
- Next by thread: [no subject]
- Indexes: