R
R
Roquie2014-09-04 20:01:51
PHP
Roquie, 2014-09-04 20:01:51

What are sequences in PostgreSQL?

There is a project written in Zend, when inserted into the database (through the view), there is a certain sequence. What it means, how it works and how to implement it - is not clear.
In another project, with the same database and the same privileges (read: the grants are the same) - the insert into the database simply does not happen. He says he's right. ...
Does it affect it somehow?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
vdem, 2014-09-04
@Roquie

Sequences in PostgreSQL - generators of unique sequences of numbers, can be used in a similar way to auto_increment fields in MySQL. Those. create a sequence for the table, when inserting a new record into it in a field that must be unique (primary key), write the value that produces the sequence created for this table.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question