Skip site navigation (1) Skip section navigation (2)

how to insert from sequence

From: soundar rajan <psrajan(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to insert from sequence
Date: 1999-10-27 14:38:38
Message-ID: 19991027143838.6280.rocketmail@web2106.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
Hi all,

I need help in inserting a value from sequence.  My
code goes like this (from Java).  I do face a syntax
level problem.

statement.execute("insert into T_name (id) values (" +
nextval('s_name') + ")");

Thanks in advance for the help.


__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com

pgsql-general by date

Next:From: Shadkam IslamDate: 1999-10-27 14:56:41
Subject: Re: [GENERAL] how to insert from sequence
Previous:From: soundar rajanDate: 1999-10-27 14:38:24
Subject: how to insert from sequence

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group