Download the PHP package kosovojs/laravel-pg-identity without Composer

laravel-pg-identity

PostgreSQL identity columns for Laravel's id() and increments() — replaces legacy serial, zero config.

What it does

On PostgreSQL, Laravel's $table->id() and increments() family generate legacy bigserial/serial columns. This package makes them generate modern identity columns instead, with no configuration required.

Install

That's it — Laravel's package auto-discovery does the rest.

How it works

The package registers a pgsql connection resolver that swaps in a PostgresConnection subclass. That subclass uses a PostgresGrammar subclass which, for auto-increment integer columns, sets generatedAs/always before delegating back to the parent grammar. Laravel's own existing modifiers then render the generated always as identity ... primary key clause and skip the serial types on their own.

Testing

Unit tests (no DB required):

End-to-end tests (installs the package into a throwaway Laravel app and checks the generated schema against real sqlite/MariaDB/Postgres databases):

Caveats

• GENERATED ALWAYS rejects explicit id inserts unless the query uses OVERRIDING SYSTEM VALUE. If you seed rows with fixed ids, the simplest opt-out is $table->id()->always(false), which gives GENERATED BY DEFAULT behavior while keeping everything else (identity type, primary key, etc). You can also call ->generatedAs() yourself on that column — the package never touches columns where generatedAs is already set — for the same effect.
• Only affects new migrations/columns — existing serial columns in your database aren't rewritten.
• Requires Laravel 12–13.
• If another package also calls Connection::resolverFor('pgsql', ...), last one registered wins.