Re: Problems with pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ben Ramsey" <ben(at)eureka-interactive(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems with pg_dump
Date: 2003-03-12 16:55:25
Message-ID: 27595.1047488125@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ben Ramsey" <ben(at)eureka-interactive(dot)com> writes:
> So, I ask: How does one drop a column from a table so that I can drop the
> affected column and then use pg_dump as normal?

If you're on 7.3 you can just drop the column. On earlier releases, I
suspect the best recourse is to select the undamaged columns into a new
table and then dump that.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Leigh W3NLB 2003-03-12 17:03:40 Re: Largest filesize under Linux
Previous Message Gabriel Fernandez 2003-03-12 16:40:55 UNSUBSCRIBE gabi@unica.edu