Saving schema in Postgresql

From Foochal

On windows

• Launch pgAdmin tool
• Connect to server
• Goto Databases -> mydatabase -> Schemas -> public
• Right click on public
• Click on backup
• Select "PLAIN"
• Check the following:
  • Only Schema
  • No owner
  • Create DB (or Drop DB, if you want to drop the schema before creating a new one, may require more rights)
• Choose the filename
• Click on Done