| public getDomain ( $domain ) : A | ||
| $domain | The name of the domain to fetch | |
| return | A | recordset |
function getDomain($domain)
{
$c_schema = $this->_schema;
$this->clean($c_schema);
$this->clean($domain);
$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.typname = '{$domain}'\n\t\t\t\tAND t.typnamespace = (SELECT oid FROM pg_catalog.pg_namespace\n\t\t\t\t\tWHERE nspname = '{$c_schema}')";
return $this->selectSet($sql);
}