Re: Create database/table using postgresql stored function - Mailing list pgsql-admin

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.fr
 http://dalibo.com