Re: Create database/table using postgresql stored function

["Manasi Save" <manasi.save@xxxxxxxxxxxxxxxxxxxxxx>]

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