| re: Exporting a PostGreSql database
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" <KumarForG@hotmail.com> wrote in message
news:68dc6f29.0307060308.1d3f32a7@posting.google.c om...[color=blue]
> 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
>[/color]
| 
