Re: [ADMIN] Create database/table using postgresql stored function

[Manasi Save]

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