Re: pg_dump is missing data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Robert Wille" <rwille(at)iarchives(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump is missing data
Date: 2004-03-26 17:23:46
Message-ID: 25084.1080321826@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Robert Wille" <rwille(at)iarchives(dot)com> writes:
> I am running Postgres 7.3.3 on RedHat Linux 7.3. I have 14 tables, but
> when I run "pg_dump -c -F p -U username dbname", the output contains no
> data for three of them. Here is the relevant output for one of the
> tables:

> COPY message (recipient, subject, body, eventtime, delivertime) FROM
> stdin;
> \.

Sure looks to me like that table is empty. Are you saying you get data
out of it when you do a manual COPY or SELECT?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2004-03-26 17:42:43 Re: CREATE TEMP TABLE
Previous Message Tom Lane 2004-03-26 17:21:59 Re: Another date / time question