- Fix ANSI labels to put EOF1 and EOF2 after each file mark.

[bacula/bacula] / bacula / src / cats / drop_postgresql_tables.in

diff --git a/bacula/src/cats/drop_postgresql_tables.in b/bacula/src/cats/drop_postgresql_tables.in
index f7cf26dda89872c3df94cf2baf637cad1ab14108..93fe437f733aa973220991896e5a64681284b600 100644 (file)
--- a/bacula/src/cats/drop_postgresql_tables.in
+++ b/bacula/src/cats/drop_postgresql_tables.in
@@ -4,8 +4,7 @@
 
 bindir=@SQL_BINDIR@
 
-if $bindir/psql $* -f - <<END-OF-DATA
-\c bacula
+if $bindir/psql -f - -d bacula $* <<END-OF-DATA
 drop table unsavedfiles;
 drop table basefiles;
 drop table jobmedia;
@@ -19,6 +18,10 @@ drop table path;
 drop table filename;
 drop table counters;
 drop table version;
+drop table CDImages;
+drop table Devices;
+drop table Storage;
+drop table MediaType;
 END-OF-DATA
 then
    echo "Deletion of Bacula PostgreSQL tables succeeded."