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); }