| From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
|---|---|
| To: | Christian Lübeck <c(dot)luebeck(at)gmx(dot)de> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Function using more than one database |
| Date: | 2002-07-26 21:45:36 |
| Message-ID: | 20020726214536.GA27840@cc.usu.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Wed, Jul 24, 2002 at 07:24:52PM +0200, Christian Lübeck wrote:
> Hi group,
>
> i am currently learning PGSQL and having a question:
>
> In DB1 i have got a table tbl1. In this table there are added, let's say 300
> rows a day. Every time, rows are added, I want to Server to move these rows
> to other DBs (DB2,DB3,DB4).
> This seems not to work with Pl/Pgsql (or maybe I don't know the right
> syntax).
> Is there any other way, any other language to do so?
Any language, except for PostgreSQL's PL languages, can do that. Just open
two (or more) connections to your different databases.
-Roberto
--
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net/
http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer
Female users not found: (C)ry, ($)*&%^#%$, (H)angUp
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roberto Mello | 2002-07-26 21:53:48 | Re: RES: [GENERAL] set DateStyle to 'SQL' |
| Previous Message | Chris Albertson | 2002-07-26 19:15:06 | Re: 1 milion data insertion |