SEO

#1 (**permalink**) 04-09-2008, 07:32 AM

Hi,

Is there a way (from DBI) to deduce a sequence name from the table and
column it is attached to?

For instance:

Column | Type | Modifiers
-------------+---------+--------------------------------------------------------------------------
id_fonction | integer | not null default nextval(('"fonction_id_fonction_seq"'::text)::regc lass)

I'd like to be able to programmatically find "fonction_id_fonction_seq"
so that I can then call nextval() on it.

Thanks,

--
Only half the people in the world are above average intelligence.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

#2 (**permalink**) 04-09-2008, 07:32 AM

Louis-David Mitterrand <vindex@apartia.org> writes:
> Is there a way (from DBI) to deduce a sequence name from the table and
> column it is attached to?

Since 8.0 you can use pg_get_serial_sequence(), see
http://www.postgresql.org/docs/8.0/s...ions-info.html

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

#3 (**permalink**) 04-09-2008, 07:32 AM

On Tue, Dec 20, 2005 at 10:31:46AM -0500, Tom Lane wrote:
> Louis-David Mitterrand <vindex@apartia.org> writes:
> > Is there a way (from DBI) to deduce a sequence name from the table and
> > column it is attached to?
>
> Since 8.0 you can use pg_get_serial_sequence(), see
> http://www.postgresql.org/docs/8.0/s...ions-info.html

Just what I needed,
Thanks!

--
-= this .sig is not funny =-

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

deduce sequence name from table and column