I have a database created with pg 7.3.1
In pgAdminII I have saved the DBSchema
After creating a new database in pgAdmin I opened a SQL box and loaded the dbschema.sql file and tried to run it.
A number of errors occured. The first was that the public namespace was already defined this was followed by:pgSQL language not defined properly, and a number of view already defined and other errors.
I worked through the batch file and eventually re-created all objects but am puzzled as to why it is not a clean operation.
Is their another way I should be running this file?
Thanks.
Richard