logo-MindMajix
L
Lakshmi sowjanya

Posted on 23rd June 2024|127 views

0
votes

Select Currval Postgresql

Select Currval() usage of PostgreSQL?

1 answers
Answers
P
Satish santu

Posted on 23rd June 2024| views

  • In any extremities, Currval() returns the current session with the last value generated by the sequence. If database servers create a sequence value parallelly, then the same sequence value is present, then currval() does not update until it produces or changes its sequence value.
  • Currval() in PostgreSQL is used to return the last value of a sequence of the current session only which can be overcome by simply using “RETURNING id;”

Write your answer

STILL GOT QUERIES?

Get a Live FREE Demo

  • Explore the trending and niche courses and learning maps
  • Learn about tuition fee, payment plans, and scholarships
  • Get access to webinars and self-paced learning videos
Name
Course *
Email *
Phone Number