If I have a table like this:

```
CREATE TABLE mytable
(
    id       SERIAL,
    content  TEXT,
    copyofid INTEGER
);

```

Is there a way to copy `id` into `copyofid` in a single insert statement?

I tried:
`INSERT INTO mytable(content, copyofid) VALUES("test", id);`

But that doesn't seem to work.