On 6/07/2011 5:24 AM, giuseppe petazzoni wrote:
> I pg_dump .sql data and schema but is no compatible db2
> or mysql or informix or oracle
No, it won't be. Few if any SQL databases are fully compatible with each
other. In particular, the schema definitions (DDL) and type names tend
to vary wildly.
This is not a bug. The SQL standard doesn't define enough detail to make
sure that different databases are fully compatible with each other.
Note that pg_dump does have some options that help to make data dumps
(not the DDL) more compatible with other databasess. In particular, you
can tell it to use INSERT commands instead of COPY. See the
documentation for pg_dump for a detailed explaination.
If you want more help with your problem, try posting on pgsql-general
and explaining what you are trying to achieve. Include the error
message(s) you get, etc. See:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
--
Craig Ringer
POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/