Re: Create database/table using postgresql stored function

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Manasi Save <manasi(dot)save(at)artificialmachines(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Create database/table using postgresql stored function
Date: 2010-12-08 10:47:31
Message-ID: 4CFF6243.6070700@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2010-12-08 10:48:59 Re: Create database/table using postgresql stored function
Previous Message Manasi Save 2010-12-08 10:04:27 Re: Create database/table using postgresql stored function