pg_dump without oids

From: Stéphane Schildknecht <stephane(dot)schildknecht(at)postgresqlfr(dot)org>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: pg_dump without oids
Date: 2007-01-17 18:13:48
Message-ID: 45AE675C.7000209@postgresqlfr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

pg_dump and pg_dumpall have the -o option that should tell them to
include oids in dump. I didn't chose this option, and the dump doesn't
include "WITH OIDS", but the tables are created with oids when restoring
this dump.

I'm dumping from 7.4.5 to 8.2.1.
I do have
#default_with_oids = off
in postgresql.conf for 8.2.

Is there a way to prevent creating table with oids ?

A table created by psql client is created without OID.

Thanks by advance

Stéphane Schildknecht

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2007-01-17 18:23:22 Re: Controlling memory of session
Previous Message Bill Moran 2007-01-17 18:01:43 Re: Index bloat of 4x