Postgres Pro
Downloads
Home   >   mailing lists

pg_dump without oids - Mailing list pgsql-general

From Stéphane Schildknecht
Subject pg_dump without oids
Date
Msg-id 45AE675C.7000209@postgresqlfr.org
Whole thread Raw
Responses Re: pg_dump without oids  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Newbie questions (pg_global, tablespace, pg_temp, ...)
Next
From: "John D. Burger"
Date:
Subject: Re: Building web sites using a database