| From: | Alexander Kuprijanov <sanya-spb(at)list(dot)ru> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | dump-restore only one table |
| Date: | 2007-05-01 10:00:38 |
| Message-ID: | 200705011400.38520.sanya-spb@list.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello
I have a stooped trable... I have equal bases <BaseA> and <BaseB>, and next
table <TableA> on each of them
CREATE TABLE <TableA>
(
idstation int4 NOT NULL DEFAULT serial,
ru_name varchar,
en_name varchar,
address varchar,
<...other fields...>
CONSTRAINT idstation_pkey PRIMARY KEY (idstation),
CONSTRAINT idcurrency_fkey FOREIGN KEY (idcurrency)
REFERENCES awp_books.idcurrency (code) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
<...other constrations...>
)
WITHOUT OIDS;
other tables have references on <TableA>,
but I need update my table <BaseB.TableA> with data from <BaseA.TableA>
I do:
==============
pg_dump -d BaseA --port=54321 --host=localhost --table=TableA --data-only -F
c -v | pg_restore -d
BaseB --data-only --no-owner --table=TableA --single-transaction -v
==============
==== output =====
pg_dump: reading schemas
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined conversions
pg_dump: reading user-defined tables
pg_dump: reading table inheritance information
pg_dump: reading rewrite rules
pg_dump: reading type casts
pg_dump: finding inheritance relationships
pg_dump: reading column info for interesting tables
pg_dump: finding the columns and types of table "idstation"
pg_dump: finding default expressions of table "idstation"
pg_dump: flagging inherited columns in subtables
pg_dump: reading indexes
pg_dump: reading indexes for table "idstation"
pg_dump: reading constraints
pg_dump: reading foreign key constraints for table "idstation"
pg_dump: reading triggers
pg_dump: reading triggers for table "idstation"
pg_dump: reading dependency data
pg_dump: saving encoding = WIN1251
pg_dump: saving standard_conforming_strings = off
pg_restore: connecting to database for restore
=============
But <BaseB.TableA> wasn't updated.... why??
--
Kiu nenion valoras, plej multe sin gloras
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2007-05-01 10:41:38 | Re: dump-restore only one table |
| Previous Message | Listmail | 2007-05-01 09:43:28 | Re: PG Books |