From: Guillaume Lelarge <guillaume@lelarge.info>
To: Manasi Save <manasi.save@artificialmachines.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Create database/table using postgresql stored function
Date: Wed, 08 Dec 2010 11:48:59 +0100
Message-ID: <4CFF629B.7030602@lelarge.info> (raw)
In-Reply-To: <20101208050427.ryccuyjfp9asowkk@mail.artificialmachines.com>
References: <20101208050427.ryccuyjfp9asowkk@mail.artificialmachines.com>
Le 08/12/2010 11:04, Manasi Save a écrit :
> Also I want to query multiple databases from stored functions from one
> central database.
> for ex :=
>
> CREATE OR REPLACE FUNCTION test () RETURNS AS
> $BODY$
>
> SELECT * FROM db2.volume
> ORDER BY db2.volume.volumeID
>
> $BODY$
> LANGUAGE sql STABLE
> COST 100
> ROWS 1000;'
>
> I have implemented this thing in mysql but I am not really sure is it
> possible in postgresql.
Nope, you can't use the same kind of queries. You need to install dblink
or PL/proxy to get that kind of capacity.
--
Guillaume
http://www.postgresql.frhttp://dalibo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: guillaume@lelarge.info, manasi.save@artificialmachines.com
Subject: Re: Create database/table using postgresql stored function
In-Reply-To: <4CFF629B.7030602@lelarge.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox