Обсуждение: pg_restore and index ...

Hi,

Just want to know how I can restore all my index with a pg_restore ??

At first I dump like that :

pg_dump -t mytable -Fc -Z9 mydb > my_dump

To restore the complete table I have tried :

pg_restore -d mydb -t mytable -Fc -i my_dump

Without any result ... I have the table created, the data restored ...
but no index !?

with -v
Connecting to database for restore
Connecting to mydb as postgres
Creating TABLE mytable
Restoring data for mytable

What about my index ?

I also try :
pg_restore -d mydb -t mytable -Fc -i myindex1 -i myindex2 my_dump
Nothing more ...

Any idea ?

Regards,
--
Hervé Piedvache

Elma Ingenierie Informatique
6, rue du Faubourg Saint-Honoré
F-75008 - Paris - France
http://www.elma.fr
Tel: +33-1-44949901
Fax: +33-1-44949902
Email: herve@elma.fr