That COPY trick is really neat. I've always used SELECT INTO. SELECT * INTO TEMP... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

luhn on Nov 9, 2021 | parent | context | favorite | on: Lesser-known Postgres features

That COPY trick is really neat. I've always used SELECT INTO.

    SELECT *
    INTO TEMP copy
    FROM foobar;
    \copy "copy" to 'foobar.csv' with csv headers

haki on Nov 9, 2021 [–]

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

luhn on Nov 9, 2021 | [–]

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;

Join us for AI Startup School this June 16-17 in San Francisco!
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact