From: Manasi Save <manasi.save@artificialmachines.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
To: Manasi Save <manasi.save@artificialmachines.com>
Subject: Re: Create database/table using postgresql stored function
Date: Wed, 08 Dec 2010 05:04:27 -0500
Message-ID: <20101208050427.ryccuyjfp9asowkk@mail.artificialmachines.com> (raw)
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.
--
Regards,
Manasi Save
On Wed, 08 Dec 2010 04:43:50 -0500, Manasi Save wrote:
Hi All,
I want to create postgresql database and tables using stored functions.
Does postgresql support create statements in stored functions.
Regards,
Manasi
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: manasi.save@artificialmachines.com
Subject: Re: Create database/table using postgresql stored function
In-Reply-To: <20101208050427.ryccuyjfp9asowkk@mail.artificialmachines.com>
* 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