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