• Open Command Prompt in Administrator Mode
  • Type command: cd C:\Program Files\PostgreSQL\13\bin
  • For Local Server, type command:
    • pg_dump -U postgres DATABASE_NAME > db_export.sql
  • For Remote Server, type command:
    • pg_dump -U postgres -h HOST_NAME DATABASE_NAME > db_export.sql
  • Enter your password & Press Enter.
  • Go to "C:\Program Files\PostgreSQL\13\bin" & find the exported file.