Database.php

<?php
class ZendDbSchema_Db_Schema_Generator_Pgsql_Database
    implements ZendDbSchema_Db_Schema_Generator_Database
{
    public function createDatabase(ZendDbSchema_Db_Schema_Database $schema)
    {
        $props = array();

        if ($schema->owner) {
            $props[] = "OWNER {$schema->owner}";
        }
        if ($schema->getCharset()) {
            $props[] = "ENCODING " . $schema->getCharset();
        }

        if ($schema->template) {
            $props[] = "TEMPLATE {$schema->template}";
        }

        if ($schema->tablespace) {
            $props[] = "TABLESPACE {$schema->tablespace}";
        }

        if ($schema->connlimit) {
            $props[] = "CONNECTION LIMIT {$schema->connlimit}";
        }

        $name    = $schema->getName();
        $query = array();
        $query[] = "DROP DATABASE IF EXISTS {$name}";
        $query[] = "CREATE DATABASE {$name} " . join(' ', $props);

        return join(';' . PHP_EOL, $query);
    }

    public function alterDatabase(ZendDbSchema_Db_Schema_Database $schema)
    {
        if (!$schema->isExist()) {
            return null;
        }

        $props = array();
        if ($schema->template) {
            $props[] = "ENCODING {$schema->template}";
        }

        if ($schema->tablespace) {
            $props[] = "TABLESPACE {$schema->tablespace}";
        }

        if ($schema->connlimit) {
            $props[] = "CONNECTION LIMIT {$schema->connlimit}";
        }

        $name = $schema->getName();

        $query = '';
        if ($schema->isDirty('charset')) {
            $charset = $schema->getCharset();
            $query = "ALTER DATABASE {$name} DEFAULT CHARACTER SET {$charset}";
        }
        return $query;
    }

    public function dropDatabase(ZendDbSchema_Db_Schema_Database $schema)
    {
        if (!$schema->isExist()) {
            return null;
        }
        return "DROP DATABASE IF EXISTS {$schema->getOriginName()}";
    }
}