Exporting a PostGreSql database

[KumarForG]

Hi,
is there a way ,
other than using EMS PostGreSql Extract
to export a PostGreSql datatbase ( table structures,data ,
functions , triggers etc... )
to sql.

i tried EMS PostGreSql Extract , but the sql is specific to
PostGreSql ( needing some editing for running on MSSql )
also the sequence of table creation was conflicting with
constraints.

Thanks In Advance

regards
-kumar

[Joe Clark]

The pg_dump command exports a database, but the results are going to be
PostgreSQL specific simply because this is the utility you use to back up
data and/or transfer databases to another server. I'm not sure what EMS is
doing, but there is an option on pg_dump that will use INSERT commands
instead of COPY. This may do the trick for you.

Joe Clark

"KumarForG" <Ku*******@hotmail.com> wrote in message
news:68**************************@posting.google.c om...

Hi,
is there a way ,
other than using EMS PostGreSql Extract
to export a PostGreSql datatbase ( table structures,data ,
functions , triggers etc... )
to sql.

i tried EMS PostGreSql Extract , but the sql is specific to
PostGreSql ( needing some editing for running on MSSql )
also the sequence of table creation was conflicting with
constraints.

Thanks In Advance

regards
-kumar