[haki]

I'm always looking for new copy tricks. Is "copy" a temporary table? Or a variable...?

[luhn]

Temporary table. Although looking at the docs it seems CREATE TABLE AS is the recommended syntax. https://www.postgresql.org/docs/13/sql-createtableas.html

    CREATE TEMP TABLE "copy" AS
    SELECT * FROM foobar;