Skip site navigation (1) Skip section navigation (2)

Re: feature request

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Omar Bettin <o(dot)bettin(at)informaticaindustriale(dot)it>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: feature request
Date: 2010-02-25 22:22:31
Message-ID: 603c8f071002251422m60c08146ubb18efe69deae937@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, Feb 25, 2010 at 5:17 PM, Omar Bettin
<o(dot)bettin(at)informaticaindustriale(dot)it> wrote:
> ...could be
> STORE WHERE [condition] FROM [table] INTO [database]

That still doesn't work, because a PostgreSQL backend doesn't have any
obvious way to access another database.  You'd need to use dblink or
something.  Eventually (but not any time soon) it will probably be
possible to do things like this, which would work for moving data
between tables in the same database:

WITH x AS (DELETE FROM ... RETURNING ...) INSERT INTO ... (...) SELECT
... FROM x

Doing anything with some OTHER database is going to require a lot more
infrastructure.

...Robert

In response to

Responses

pgsql-hackers by date

Next:From: Omar BettinDate: 2010-02-25 22:29:18
Subject: Re: feature request
Previous:From: Omar BettinDate: 2010-02-25 22:17:03
Subject: Re: feature request

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group