Re: Using sequences in SQL text files - Mailing list pgsql-general

From Lone Wolf
Subject Re: Using sequences in SQL text files
Date
Msg-id 883119.53700.qm@web51107.mail.re2.yahoo.com
Whole thread Raw
In response to Re: Using sequences in SQL text files  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Can I have something like this in my SQL text file:
(items_seq.nextval(), '....', '...')
?

Raymond O'Donnell <rod@iol.ie> wrote:
On 19/02/2008 15:43, HHB wrote:

> How to use a sequence in such text files?

You're looking for the nextval() function - look it up in the docs.

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------



Deep into that darkness peering, long I stood there, wondering, fearing, Doubting, dreaming dreams no mortal ever dreamed before.
E.A Poe
 


Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

pgsql-general by date:

Previous
From: George Weaver
Date:
Subject: Alter Domain Type
Next
From: brian
Date:
Subject: Re: Using sequences in SQL text files