PostgreSQL mentés és visszatöltés

#EXPORT
pg_dump -C -h localhost -U USER_NAME DATABASE_NAME

#TÁBLÁK TÖRLÉSE - DELETE TABLES
psql -h localhost DATABASE_NAME -t -c "select 'drop table \"' || tablename || '\" cascade;' from pg_tables where schemaname='public'" | psql -h localhost DATABASE_NAME

#IMPORT
psql DATABASE_NAME < database.sql