Exporting a PostGreSql database

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • KumarForG
    #1

    Exporting a PostGreSql database

    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
    Tags: None
    • Joe Clark
      #2
      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@hotm ail.com> wrote in message
      news:68dc6f29.0 307060308.1d3f3 [email protected] gle.com...[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]


        Comment

        Previous template Next
        Working...