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


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

On 12/20/05, Oleg <evdakov@iwk.uka.de> wrote:
> 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.

when you install postgres with the pgInstaller you can choose to
enable postgis by default...

just running the sql generated by pg_dump should work...


--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings