Error when calling for last value in sequence in PostgreSQL

Question

I'm trying to get the last value of a sequence in my database, and acording to what i found, the query should be done like this: SELECT last_value FROM my_sequence. However, when i hit enter, the only thing I get in the console is:

ERROR:  relation "my_sequence" does not exist
LINE 1: select last_value from my_sequence;
                               ^

Any help?

Edit: the sequence does exist, for I do get the name of it when I list all sequences

The error message is clear: Table/View/Alias/Whatever with name my_sequence does not exist. Maybe a typo? — S-Man
– S-Man, Commented Feb 18, 2021 at 11:53
@S-Man unfortunately no, I've even tried copy-pasting the name of the sequence — Juan Cruz Carrau
– Juan Cruz Carrau, Commented Feb 18, 2021 at 11:55
That worked!! Thank you so much. However, i was under the impresion that i was already in that schema in my console, so i don't get why that happened — Juan Cruz Carrau
– Juan Cruz Carrau, Commented Feb 18, 2021 at 12:01

Laurenz Albe · Accepted Answer · 2021-02-18 12:24:39Z

1

You have to define the schema you are using:

SELECT last_value FROM my_schema.my_sequence

edited Feb 18, 2021 at 12:24

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

answered Feb 18, 2021 at 12:03

S-Man

24k9 gold badges51 silver badges78 bronze badges

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

2 Comments

Juan Cruz Carrau Over a year ago

I haven't enough reputation so as to vote, but believe me, I really do apreciate it

Juan Cruz Carrau Over a year ago

There you go. Thanks!

Vinay Hegde · Accepted Answer · 2021-02-18 12:02:29Z

1

Try this :

select currval('my_sequence')

OR

select currval('my_schema.my_sequence')

edited Feb 18, 2021 at 12:02

answered Feb 18, 2021 at 11:55

Vinay Hegde

1,4481 gold badge14 silver badges24 bronze badges

3 Comments

Juan Cruz Carrau Over a year ago

Same error, with and without the apostrophes

Vinay Hegde Over a year ago

Did you tied currval ?

Juan Cruz Carrau Over a year ago

Now it does recognize the sequence, still, aonly works if i've used the sequence in the current session. Anyways, thank you so much!

Collectives™ on Stack Overflow

Error when calling for last value in sequence in PostgreSQL

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related