Postgres::getSequences PHP Method

    function getSequences($all = false)
    {
        if ($all) {
            // Exclude pg_catalog and information_schema tables
            $sql = "SELECT n.nspname, c.relname AS seqname, u.usename AS seqowner\n\t\t\t\tFROM pg_catalog.pg_class c, pg_catalog.pg_user u, pg_catalog.pg_namespace n\n\t\t\t\tWHERE c.relowner=u.usesysid AND c.relnamespace=n.oid\n\t\t\t\tAND c.relkind = 'S'\n\t\t\t\tAND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast')\n\t\t\t\tORDER BY nspname, seqname";
        } else {
            $c_schema = $this->_schema;
            $this->clean($c_schema);
            $sql = "SELECT c.relname AS seqname, u.usename AS seqowner, pg_catalog.obj_description(c.oid, 'pg_class') AS seqcomment,\n\t\t\t\t(SELECT spcname FROM pg_catalog.pg_tablespace pt WHERE pt.oid=c.reltablespace) AS tablespace\n\t\t\t\tFROM pg_catalog.pg_class c, pg_catalog.pg_user u, pg_catalog.pg_namespace n\n\t\t\t\tWHERE c.relowner=u.usesysid AND c.relnamespace=n.oid\n\t\t\t\tAND c.relkind = 'S' AND n.nspname='{$c_schema}' ORDER BY seqname";
        }
        return $this->selectSet($sql);
    }