Re: [Q] Sequences, last_value and inserts - Mailing list pgsql-general

"Roderick A. Anderson" <raanders@acm.org> writes:

> On Fri, 1 Nov 2002, Bruno Wolff III wrote:
>
> > You want to use currval. This can be used within a single session safely.
>
> I must be thick today.
>
> select currval from domain_info_tbl_key_seq;
> ERROR:  Attribute 'currval' not found

Try:

select currval('domain_info_tbl_key_seq');

If you read the docs, you would know this.  ;)

-Doug