Partial table copy?

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(at)pbegames(dot)com ----> http://www.pbegames.com/~thomas
Play by Electron Games -> http://www.pbegames.com Free Trial Games