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/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
