Обсуждение: BUG #6091: Information

Поиск
Список
Период
Сортировка

BUG #6091: Information

От
"giuseppe petazzoni"
Дата:
The following bug has been logged online:

Bug reference:      6091
Logged by:          giuseppe petazzoni
Email address:      giuseppe.petazzoni@libero.it
PostgreSQL version: 8.4.7
Operating system:   linux debian 6.0.1
Description:        Information
Details:

Dear Ser

I pg_dump .sql data and schema but is no compatible db2
or mysql or informix or oracle

You have a solution , becouse I have a problem for the compatibility of
portability Postgresql database scripts
.sql in other database

                Sincerely Giuseppe PETAZZONI
                         Italy

Re: BUG #6091: Information

От
Craig Ringer
Дата:
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/