@echo off
cls
rem
rem script to build insert Toponymie française inside MDweb database thesaurus on windows 
rem
echo ---------------------------------------------------------------------------
echo this script is made to add a the Toponymie française thesaurus 
echo inside your current thesaurus database
set /p bdmdweb=Give the name of the current thesaurus database for MDweb ? : 
if("%bdmdweb%")==("") goto bd_vide
echo ----------------------------------------------------------------------------
echo the Toponymie française  will be inserted in the database %bdmdweb% 
echo ----------------------------------------------------------------------------
pause
psql -d  %bdmdweb% -U postgres < dump-toponyme-fra.sql
goto end
:bd_vide
echo ----------------------------------------------------
echo you don't input the name of MDweb database
echo ----------------------------------------------------
pause
goto eof
:eof
echo ---------------------------------------------------------------------
echo the insertion of Toponymie française inside your database was aborted
echo ---------------------------------------------------------------------
 pause
 exit
:end
echo -------------------------------------------------------
echo the insertion of Toponymie française inside 
echo the database named : %bdmdweb% is successful
echo -------------------------------------------------------
pause