Re: pg_dump is missing data - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump is missing data
Date
Msg-id 25084.1080321826@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump is missing data  ("Robert Wille" <rwille@iarchives.com>)
List pgsql-general
"Robert Wille" <rwille@iarchives.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

pgsql-general by date:

Previous
From: "Evil Monkey"
Date:
Subject: Help needed with normalisation
Next
From: Tom Lane
Date:
Subject: Re: Another date / time question