| public getSchemaByName ( $schema ) : Schema | ||
| $schema | The name of the schema | |
| return | Schema | information |
function getSchemaByName($schema)
{
$this->clean($schema);
$sql = "\n\t\t\tSELECT nspname, nspowner, r.rolname AS ownername, nspacl,\n\t\t\t\tpg_catalog.obj_description(pn.oid, 'pg_namespace') as nspcomment\n\t\t\tFROM pg_catalog.pg_namespace pn\n\t\t\t\tLEFT JOIN pg_roles as r ON pn.nspowner = r.oid\n\t\t\tWHERE nspname='{$schema}'";
return $this->selectSet($sql);
}