Re: Create database/table using postgresql stored function - Mailing list 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