psql
Start with a clean slate
drop table if exists t;
create table t(x int);
insert into t values (1), (2), (3);
select * from t;
- Drop the table if it exists.
- Then proceed as before.
jao@mintyzack ~ $ psql jao < test.sql
Pager usage is off.
INSERT 0 3
x
---
1
2
3
(3 rows)
jao@mintyzack ~ $ psql jao < test.sql
Pager usage is off.
INSERT 0 3
x
---
1
2
3
(3 rows)
|