25 ms·
I'm always looking for new copy tricks. Is "copy" a temporary table? Or a variable...?
by haki 5y ago
I'm always looking for new copy tricks. Is "copy" a temporary table? Or a variable...?
- luhn 5y agoTemporary table. Although looking at the docs it seems CREATE TABLE AS is the recommended syntax. https://www.postgresql.org/docs/13/sql-createtableas.html https://www.postgresql.org/docs/13/sql-createtableas.html CREATE TEMP TABLE "copy" AS SELECT * FROM foobar;