Postgres::alterSequenceSchema PHP Method

alterSequenceSchema() public method

Alter a sequence's schema
public alterSequenceSchema ( $seqrs, $schema )
$seqrs The sequence RecordSet returned by getSequence()
    function alterSequenceSchema($seqrs, $schema)
    {
        /* vars are cleaned in _alterSequence */
        if (!empty($schema) && $seqrs->fields['nspname'] != $schema) {
            $f_schema = $this->_schema;
            $this->fieldClean($f_schema);
            $sql = "ALTER SEQUENCE \"{$f_schema}\".\"{$seqrs->fields['seqname']}\" SET SCHEMA {$schema}";
            return $this->execute($sql);
        }
        return 0;
    }
Postgres