http://turedure.oboroduki.com/find11.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
a record variable for further processing. So my
query actually is
EXECUTE 'SELECT * FROM "' || table || '" INTO "record_data" WHERE
';
This one will not work with the following error message:
ERROR: syntax error at or near "INTO"
Can some one help me ?
Thanks,
Sairam Krishnamurthy
+1 612 859 8161
All,
I have a rule written on a temp table which will copy the values
inserted into it to another table applying a function. The temp table
will be discarded then. The rules I have written works when I use
"Insert into" the temp table. But when I use bulk copy "COPY FROM", the
rule doesn't ge
trailing zeros when querying, but I am interested in finding why an
additional trailing zero returns an empty set.
--
Thanks,
Sairam Krishnamurthy
+1 612 859 8161
updating database A always. I want the update to be backed up
to database B automatically during the night when no one will be using
the databases.
Can some one tell if if this can be done and if yes how ?
Thanks,
Sairam Krishnamurthy
+1 612 859 8161
On 10/04/2010 06:31 PM, Ben Madin wrote:
I
Scott, Thanks to answering the question. Thats exactly the reason.
Also any operation on the tables is going to be huge. LIke 10s of
thousands of rows inserted of deleted. This basically locks the table
and that y we wanted to update a database and sync it with the
production database when no one
synchronous databases.
On Mon, Oct 4, 2010 at 6:31 PM, Ben Madin
wrote:
> I think you want something like :
> http://www.postgresql.org/docs/8.4/interactive/backup.html
> On 05/10/2010, at 7:02 AM, Sairam Krishnamurthy wrote:
>
> Hi all.
>
> I am trying to create two datab
using
the databases.
Can some one tell if if this can be done and if yes how ?
--
Thanks,
Sairam Krishnamurthy
+1 612 859 8161