Postgres::getSequence PHP Method

getSequence() public method

Returns properties of a single sequence
public getSequence ( $sequence ) : A
$sequence Sequence name
return A recordset
    function getSequence($sequence)
    {
        $c_schema = $this->_schema;
        $this->clean($c_schema);
        $c_sequence = $sequence;
        $this->fieldClean($sequence);
        $this->clean($c_sequence);
        $sql = "\n\t\t\tSELECT c.relname AS seqname, s.*,\n\t\t\t\tpg_catalog.obj_description(s.tableoid, 'pg_class') AS seqcomment,\n\t\t\t\tu.usename AS seqowner, n.nspname\n\t\t\tFROM \"{$sequence}\" AS s, pg_catalog.pg_class c, pg_catalog.pg_user u, pg_catalog.pg_namespace n\n\t\t\tWHERE c.relowner=u.usesysid AND c.relnamespace=n.oid\n\t\t\t\tAND c.relname = '{$c_sequence}' AND c.relkind = 'S' AND n.nspname='{$c_schema}'\n\t\t\t\tAND n.oid = c.relnamespace";
        return $this->selectSet($sql);
    }
Postgres