Re: Question / Joel /BE

From: Alexander Dederer <dederer(at)spb(dot)cityline(dot)ru>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Question / Joel /BE
Date: 2001-05-16 21:17:39
Message-ID: 9duqlu$2gqi$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jo?l Francken wrote:
> I'd like to know if it is possible to select data from a db on a server
> and then to insert it on an other server ?
> Is there somth like
>
> SELECT * INTO backup FROM server.database.table;
>
> Is there an alternate solution ?

As I know it's in 7.1.1 not working.
Try Perl with 2 connections to 2 databases. And use CURSOR !!!

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Alexander Dederer 2001-05-16 22:03:31 Re: Need Help in creating script
Previous Message Prashant Sinha 2001-05-16 21:16:00 Need Help in creating script