| From: | Manasi Save <manasi(dot)save(at)artificialmachines(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, "Manasi Save" <manasi(dot)save(at)artificialmachines(dot)com> |
| Subject: | Re: Create database/table using postgresql stored function |
| Date: | 2010-12-08 10:04:27 |
| Message-ID: | 20101208050427.ryccuyjfp9asowkk@mail.artificialmachines.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2010-12-08 10:47:31 | Re: Create database/table using postgresql stored function |
| Previous Message | Manasi Save | 2010-12-08 09:43:50 | Create database/table using postgresql stored function |