Postgres Pro
Downloads
Home   >   mailing lists

Re: Create database/table using postgresql stored function - Mailing list pgsql-admin

From Guillaume Lelarge
Subject Re: Create database/table using postgresql stored function
Date
Msg-id 4CFF6243.6070700@lelarge.info
Whole thread Raw
In response to Create database/table using postgresql stored function  ("Manasi Save" <manasi.save@artificialmachines.com>)
List pgsql-admin
Tree view 
Le 08/12/2010 10:43, Manasi Save a écrit :
> [...]
> I want to create postgresql database and tables using stored functions.
>
> Does postgresql support create statements in stored functions.
>

You cannot use CREATE DATABASE from a stored function or in a
multistatements query. But AFAICT, any of the other DDL statements are
available in a stored function (or in a transaction for that matter).


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

pgsql-admin by date:

Previous
From: "Manasi Save"
Date:
Subject: Re: Create database/table using postgresql stored function
Next
From: Guillaume Lelarge
Date:
Subject: Re: Create database/table using postgresql stored function