pomm-project / Foundation

     * @param  int         $table_oid

     * @return string|null

     */

    public function getTableComment($table_oid)

    {

        $sql      = <<<SQL

select description from pg_catalog.pg_description where :condition

SQL;

        $where    = Where::create('objoid = $*', [$table_oid]);

        $iterator = $this->executeSql($sql, $where);

        return $iterator->isEmpty() ? null : $iterator->current()['description'];

    }

    /**

     * getTypeInformation

     * @param  int        $oid

     * @return array|null

     */

    public function getTypeCategory($oid)

    {

        $sql = <<<SQL

select

    case

        when n is null then t.type_name

        else n.nspname||'.'||t.type_name

    end as "name",

    t.typcategory as "category"

from

    pg_catalog.pg_type t

        left join pg_namespace n on n.oid = t.typnamespace

where

    :condition

SQL;

        $iterator = $this->executeSql($sql, Where::create('t.oid = $*', [$oid]));

        return $iterator->isEmpty() ? null : $iterator->current();

    }

    /**

     * getTypeEnumValues