| public getDomains ( ) : All | ||
| return | All | tables, sorted alphabetically |
function getDomains()
{
$c_schema = $this->_schema;
$this->clean($c_schema);
$sql = "\n\t\t\tSELECT\n\t\t\t\tt.typname AS domname,\n\t\t\t\tpg_catalog.format_type(t.typbasetype, t.typtypmod) AS domtype,\n\t\t\t\tt.typnotnull AS domnotnull,\n\t\t\t\tt.typdefault AS domdef,\n\t\t\t\tpg_catalog.pg_get_userbyid(t.typowner) AS domowner,\n\t\t\t\tpg_catalog.obj_description(t.oid, 'pg_type') AS domcomment\n\t\t\tFROM\n\t\t\t\tpg_catalog.pg_type t\n\t\t\tWHERE\n\t\t\t\tt.typtype = 'd'\n\t\t\t\tAND t.typnamespace = (SELECT oid FROM pg_catalog.pg_namespace\n\t\t\t\t\tWHERE nspname='{$c_schema}')\n\t\t\tORDER BY t.typname";
return $this->selectSet($sql);
}