Skip to content

Instantly share code, notes, and snippets.

@LarsKumbier
Last active April 16, 2019 03:48
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save LarsKumbier/edae700e5a44fbccbbc44978d3402b0e to your computer and use it in GitHub Desktop.
Save LarsKumbier/edae700e5a44fbccbbc44978d3402b0e to your computer and use it in GitHub Desktop.
Export Postgresql for mongoimport
COPY (
SELECT
userid AS "userId.auto()",
'some-static-string' AS "__classname__.auto()",
failed_login_count AS "failedLoginCount.int32()",
CASE WHEN mail_validated=TRUE THEN 'TRUE' ELSE 'FALSE' END AS "mailValidated.boolean()",
-42 AS "answers.toTheQuestion.int32()",
'Slate Star Codex' AS "answers.niceBlog.auto()"
FROM
users.accounts
) TO '/tmp/users-accounts.csv' WITH (FORMAT CSV, HEADER TRUE, DELIMITER E'\t');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment