Suggest a feature
×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: Text
Posted by: Hugo Felipe
Added: May 24, 2018 7:56 PM
Modified: May 31, 2018 3:02 PM
Views: 14
Tags: no tags
  1. Importar e Exportar Postgresql
  2.  
  3. --- LINUX
  4.  
  5. PGPASSWORD="postgrizza" pg_restore --host localhost --port 5432 --username "idealizza" --dbname "portalhm" portalnova.custom
  6. export PGPASSWORD="j5@9#b3q475f" && pg_dump -Fc -x -T log -h localhost -U postgres tee_finance -f teenow.custom
  7.  
  8. --- WINDOWS
  9.  
  10. C:\Program Files\PostgreSQL\pg94\bin\pg_restore.exe --host localhost --port 5432 --username "postgres" --dbname "teenow" --no-password  --no-owner --no-privileges --verbose "C:\Users\hfeli\Desktop\teenow.custom"