pg_dump is missing data

Поиск
Список
Период
Сортировка
От Robert Wille
Тема pg_dump is missing data
Дата
Msg-id 00a601c412bb$35f5ebf0$2864a8c0@habanero
обсуждение исходный текст
Ответы Re: pg_dump is missing data  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

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:

 

--

-- TOC entry 9 (OID 16990)

-- Name: message; Type: TABLE; Schema: public; Owner: jobq

--

 

CREATE TABLE message (

    recipient character varying(60) NOT NULL,

    subject character varying(2000) NOT NULL,

    body character varying(2000) NOT NULL,

    eventtime timestamp with time zone NOT NULL,

    delivertime timestamp with time zone NOT NULL

);

 

--

-- Data for TOC entry 40 (OID 16990)

-- Name: message; Type: TABLE DATA; Schema: public; Owner: jobq

--

 

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

\.

 

I really need some help on this. This database runs the company I work for.

 

Robert Wille

 

 

В списке pgsql-general по дате отправления:

Предыдущее
От: "Vanole, Mike"
Дата:
Сообщение: Another date / time question
Следующее
От: billybobc1210@yahoo.com (Bill C.)
Дата:
Сообщение: Questions on production rollout