Delete data from postgres database

Question

I use postgres with jdbc and I would like to delete all data from database without dropping any tables!! I would like to insert data in database using this

 <jdbc:initialize-database data-source="DataSource"> 
 <jdbc:script location="classpath:META-INF/test.sql"/> 
 </jdbc:initialize-database>

the problem is that I got a key duplicated exception, so I have to delete all data before running this code any idea?

You can dump the DB (with pg_dump) and restore it without table content. Only table structure. — Ihor Romanchenko
– Ihor Romanchenko, Commented Jun 24, 2014 at 11:17

Kabulan0lak · Accepted Answer · 2014-06-24 11:17:01Z

1

Add a TRUNCATE your_table; for all your tables at the beginning of your test.sql file.

answered Jun 24, 2014 at 11:17

Kabulan0lak

2,1361 gold badge21 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Delete data from postgres database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related