Search Postgresql Archives

Re: dump-restore only one table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tuesday 01 May 2007 18:43:37 Tom Lane wrote:
> Alexander Kuprijanov <sanya-spb@xxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux