I have a table that was created like this:
CREATE SEQUENCE "id_seq" START 1 INCREMENT 1;
CREATE TABLE "players"
(
"pid" integer PRIMARY KEY DEFAULT nextval('id_seq') NOT NULL,
"pname" text,
"value" integer,
);
For testing purposes I'd like to create some test data:
COPY "players" FROM stdin;
1 Bill 8
2 Frank 100
\.
This works, but leaves my sequence out of sync with my actual data. What
I'd really like is:
COPY "players" FROM stdin;
nextval('id_seq') Bill 8
nextval('id_seq') Frank 100
\.
Obviously that won't work. I guess I can do:
INSERT INTO "players" (pname, value) VALUES ('Bill', 8);
INSERT INTO "players" (pname, value) VALUES ('Frank', 100);
But that seems less intuitive. Is there a better way?
Mark Thomas
---
thomas@pbegames.com ----> http://www.pbegames.com/~thomas
Play by Electron Games -> http://www.pbegames.com Free Trial Games
