hello,
i'm having trouble inserting values into my database. I want create a table that will auto-increment everytime i insert a new row. this is the command i used to create myTable:
[code]
create table myTable (id serial, names text);
[code]

now when i try to insert a new record by doing:
i get an error saying it can't be parsed. but when i do:
if works fine, but my question is----is there a way i can create a table that every time i create do an insert it will increment my id field, for example
i want my database to increment the id column by one and insert myName into my database.

thanks,

djgerbavor3

Which version of PGSQL are you using? In 7.4 and
newer it SHOULD work like that
Alternatively try:

Cheers,
Tink

I believe you need to entry the data as such. That way the id field will auto increment.
INSERT INTO myTable (names) VALUES ('myname');

that worked fine, thanks, but why do you think i have to put names in parthenise?

thanks,

djgerbavor3

Std SQL:

INSERT INTO tablename
(
col1, col2, ..)
VALUES
(val1, val2, ..)
;


Note that if you do NOT specify col names, values will be inserted in in the order that the cols exist on the table... this is not reqd to be the order you used in the CREATE statement (although it usually is).
Basically, NEVER assume ... always specify. You can however skip cols that you do not supply values for.
HTH

It just the command language syntax.

The following also works:
insert into myTable values(DEFAULT, "myName");

Because string can be everything. Imagine this:
INSERT INTO table VALUES ("one, two, three");
Without quotes it will be used as separate parameters. Note that you should in fact quote all values.

I mean the actually column named name.


insert into table myTable (name) values("foo");

So the database knows which column to insert the
value to ... you need to a) either specify ALL values
(including the WORD default for the automatic columns)
or b) tell it which columns you want to populate.


Cheers,
Tink

thanks, i did that and it worked perfectly.


thanks again

djgerbavor3