CakePHP / Postgres nextval()

Question

in CakePHP how would go about running this query? It's to get the next sequence value in a postgres DB.

"SELECT nextval('book_id_seq')"

I'm used to using a syntax like $this->find('all') but that wouldn't work afaik.

api55 · Accepted Answer · 2011-12-15 12:21:00Z

2

This kind of query you can do it with the query function

$model->query($query);

$query is "SELECT nextval('book_id_seq')";

some special queries have to be done like this... at most you may get last inserted id in mysql

hope this helps you :)

answered Dec 15, 2011 at 12:21

api55

11.5k4 gold badges44 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1