1 min read

Execute "COPY .. FROM stdin" in postgres database

Execute "COPY .. FROM stdin" in postgres database

psql -h HOST -p PORT -f import.sql -U USER -d DEFAULTDB

  • HOST
  • PORT
  • USER
  • DEFAULTDB

import.sql

COPY public.mytable (id, name, surname) FROM stdin;
1 yuri bacciarini
2 marla swinger
3 tyler durden
Tweets by YBacciarini