Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group