Re: dump-restore only one table

On Tuesday 01 May 2007 18:43:37 Tom Lane wrote:
> Alexander Kuprijanov <sanya-spb(at)list(dot)ru> writes:
> > but pg_restore dont want make its work...
> > ====================================
> > % pg_restore --dbname=BaseB --no-owner --table=TableA -v
> > ./idstation.backup pg_restore: connecting to database for restore
> > pg_restore: implied data-only restore
> > ====================================
>
> Works for me. Perhaps your table name is mixed-case and you didn't
> quote it correctly? Have you tried 'pg_restore -l' to verify what
> is in the dump file?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

no, tablenames not mixed, all small-case letter

% pg_restore -l ./idstation.backup
;
; Archive created at Tue May 1 18:56:55 2007
; dbname: ArisPSQLBase
; TOC Entries: 4
; Compression: -1
; Dump Version: 1.10-0
; Format: CUSTOM
; Integer: 4 bytes
; Offset: 8 bytes
; Dumped from database version: 8.1.9
; Dumped by pg_dump version: 8.2.4
;
;
; Selected TOC Entries:
;
2969; 0 0 SEQUENCE SET awp_books idstation_idstation_seq pgsql
2966; 0 17400628 TABLE DATA awp_books idstation pgsql

--
Marĉandado aĉeti ne devigas