drop table if exists my_table cascade;
create table my_table(id int, str text);
copy my_table from stdin;
1   a
2   b
.
select * from my_table;

$ psql -f /data/script.sql test postgres
DROP TABLE
CREATE TABLE
COPY 2
 id | str
----+-----
  1 | a
  2 | b
(2 rows)