dbmover/pgsql-sequences

Dbmover plugin to handle PostgreSQL sequences

Dbmover\PgsqlSequences

DbMover plugin to handle PostgreSQL sequences, _(*1)

PostgreSQL uses "sequences" or "serials" to implement auto-incrementing columns. This plugin adds support for them in your schema's, since they are an extension to SQL., _(*2)

Installation

$ composer require dbmover/pgsql-sequences

This package is part of the `dbmover/pgsql` meta-package.

Usage

For general DbMover usage, see dbmover/core., _(*3)

PostgreSQL allows a shorthand data type SERIAL for serial columns. This is actually an alias to INTEGER that also implicitly creates a sequence if it does not exist yet (with the name TABLE_COLUMN_seq). Since SERIAL isn't a "real" data type, DbMover does not support it. You should explicitly create sequences, use actual column types for them (INTEGER or BIGINT) and explicitly use PostgreSQL's NEXTVAL function to define the column's default value., _(*4)

As an example:, _(*5)

CREATE SEQUENCE foo_id_seq;

CREATE TABLE foo (
    INTEGER id NOT NULL PRIMARY KEY DEFAULT NEXTVAL('foo_id_seq'::regclass)
);

The plugin checks if the requested sequence doesn't already exist. If it does, it is skipped. So, no need to add IF NOT EXISTS clauses as introduced in PostgreSQL 9.5. You're allowed to add them for peace of mind, though., _(*6)

Contributing

See dbmover/core., _(*7)