Thread: The -o command line option of pg_dump for a database using foreign keys

PostgreSQL 7.1.2 Administrator's Guide says as follows:

    Chapter 8. Backup and Restore
    8.1. SQL Dump

    Important: When your database schema relies on OIDs (for instances as
    foreign keys) you must instruct pg_dump to dump the OIDs as well. To do
    this, use the -o command line option.

Is the -o option still required for 7.1.2 version for a database using foreign
keys?


Kind regards,


Kenji Sugita
sugita@sra.co.jp

> PostgreSQL 7.1.2 Administrator's Guide says as follows:
>
>     Chapter 8. Backup and Restore
>     8.1. SQL Dump
>
>     Important: When your database schema relies on OIDs (for instances as
>     foreign keys) you must instruct pg_dump to dump the OIDs as well. To do
>     this, use the -o command line option.
>
> Is the -o option still required for 7.1.2 version for a database using foreign
> keys?

Only if you use object ids (OID's).

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026