Try
statement.execute("insert into T_name (id) values (nextval('s_name'))");
Regards,
Shad.
On Wed, 27 Oct 1999, soundar rajan wrote:
> 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.exec
Hi All,
If I type \h insert at psql it shows me,
INSERT INTO class_name [(attr1, ...attrN)]
VALUES (expr1,..exprN) |
SELECT [DISTINCT [ON attrN]]
expr1, ...exprN
[FROM from_clause]
[WHERE qual]
[GROUP BY group_list]
[HAVING having_c
Just to add to it...
If you want to drop a column and you do not want to lose data from the
table you may follow the following sequence,
select field1,field2... from TableToBeChanged
into TableToBeChanged_OldData;
where field1,field2... will be having all the columns except the one you
want to
