Skip to content

pgsql.md

Latest commit

 

History

History
43 lines (30 loc) · 1.25 KB

pgsql.md

File metadata and controls

43 lines (30 loc) · 1.25 KB

PostgreSQL Additions

These 'pgsql' query objects have additional PostgreSQL-specific behaviors.

INSERT

  • returning() to add a RETURNING clause

Last Insert IDs and Table Inheritance

PostgreSQL determines the default sequence name for the last inserted ID by concatenating the table name, the column name, and a seq suffix, using underscore separators (e.g. table_col_seq).

However, when inserting into an extended or inherited table, the parent table is used for the sequence name, not the child (insertion) table. This package allows you to override the default last-insert-id name with the method setLastInsertIdNames() on both QueryFactory and the Insert object itself. Pass an array of inserttable.col keys mapped to parenttable_col_seq values, and the Insert object will use the mapped sequence names instead of the default names.

$queryFactory->setLastInsertIdNames([
    'child.id' => 'parent_id_seq'
]);

$insert = $queryFactory->newInsert();
$insert->into('child');
// ...
$seq = $insert->getLastInsertIdName('id');

The $seq name is now parent_id_seq, not child_id_seq as it would have been by default.

UPDATE

  • returning() to add a RETURNING clause

DELETE

  • returning() to add a RETURNING clause