| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Omar Bettin | 2010-02-25 22:29:18 | Re: feature request |
| Previous Message | Omar Bettin | 2010-02-25 22:17:03 | Re: feature request |