Dear all,
How to copy all tables and views from Linux PostgreSQL to Windows? The
database under Linux is PostGIS enabled. By default pg_dump saves all
PostGIS's CREATE FUNCTION commands that are pointed to the Linux's *.so
files.
In order to properly create database under Windows I would like to do
following:
1. Create database under windows
2 create all functions pointing to *.dll using provided sql file
3 Backup all tables and views with their rools
4 Restore backup under Windows
Are those steps correct?
How do I perform steps 3 and 4?
Thanks a lot in advance
Oleg