By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,780 Members | 1,229 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,780 IT Pros & Developers. It's quick & easy.

Exporting a PostGreSql database

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
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

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.