Обсуждение: Cannot restore table using pg_restore

I am new to PostgreSQL and am running 8.3.3 on Windows XP Pro SP3. I
have dumped a database using the following command.

pg_dump --format=custom --username=postgres
--file=c:\pgdb\dumps\app.backup app

I am trying to restore a table named contact in the contact schema. I
have tried two methods. The first is the command

pg_restore --dbname=app --format=custom --schema=contact
--table=contact.contact --username=postgres --single-transaction
contact.backup

Note that I renamed the dump file from app.backup to contact.backup.
This command runs without any error messages but does not restore the table.

I also used the -l option to create a list file then deleted all of the
items I do not want to restore leaving the following in the file
contact.list.

;
; Archive created at Fri Nov 21 19:40:17 2008
;     dbname: app
;     TOC Entries: 139
;     Compression: -1
;     Dump Version: 1.10-0
;     Format: CUSTOM
;     Integer: 4 bytes
;     Offset: 8 bytes
;     Dumped from database version: 8.3.3
;     Dumped by pg_dump version: 8.3.3
;
;
; Selected TOC Entries:
;
1591; 1259 25326 TABLE contact contact postgres
1592; 1259 25334 VIEW contact company postgres
1919; 0 25326 TABLE DATA contact contact postgres
1890; 2606 25333 CONSTRAINT contact contact_id_unique postgres

I have used the list file above with the following command.

pg_restore -L contact.list contact.backup > result.txt

This also runs without error but does not restore anything. The contents
of the result.txt file are at the end of this message with only the data
in the copy command removed. I must be doing something wrong but after
three hours I cannot see what I am missing.

Bill

--
-- PostgreSQL database dump
--

SET client_encoding = 'WIN1252';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = contact, pg_catalog;

--
-- Data for Name: contact; Type: TABLE DATA; Schema: contact; Owner:
postgres
--

COPY contact (id, last_name, first_name, company, work_phone, extension,
home_phone, honorific, title, address_1, address_2, city, state, zip,
country, fax, spouse, type, keyword, speed_dial, email, url, note) FROM
stdin;
\.


SET default_tablespace = '';

--
-- Name: contact_id_unique; Type: CONSTRAINT; Schema: contact; Owner:
postgres; Tablespace:
--

ALTER TABLE ONLY contact
    ADD CONSTRAINT contact_id_unique PRIMARY KEY (id);


--
-- PostgreSQL database dump complete
--

Bill Todd <pg@dbginc.com> writes:
> I am trying to restore a table named contact in the contact schema. I
> have tried two methods. The first is the command

> pg_restore --dbname=app --format=custom --schema=contact
> --table=contact.contact --username=postgres --single-transaction
> contact.backup

The correct incantation is
    --schema=contact --table=contact
You can use the qualified-name syntax in pg_dump's --table switch,
but nobody's gotten around to making pg_restore similarly bright.


> pg_restore -L contact.list contact.backup > result.txt
> This also runs without error but does not restore anything.

Well, in that form it's not supposed to do anything except emit SQL
into result.txt --- you probably want to use the -d switch, or else
pipe the SQL into psql.

            regards, tom lane