KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
My computer broke down but fortunately I backed up the folder C:\Program Files\PostgreSQL. Now I'm working in a new computer and I would like to import the previous Postgres databases that are stored in the external disk. I would like to export the schema of a specific database that is located in the backup folder. The file PostgreSQL\8.3\data\global\pg_database contains information about databases and their OIDs; for example: "db1" 20012 "db2" 23456 I would like to export the schema of "db1". There is a folder named "20012" in folder "PostgreSQL\8.3\data\base\20012" that contains a lot of files [500 files]. Is there any way to export the schema of that database? Note that all of the Postgresql database files are located in an external hard disk and I would like to export the schema of that database in an SQL file, take that file, run it and create the same exact database locally.
Tags (comma-separated)
Save Edits
Cancel