restore a table in a database

Поиск
Список
Период
Сортировка
Искать
От
Marc Fromm
Тема
restore a table in a database
Дата
Msg-id
B0D7C0A3F35FE144A70312D086CBCA9B0213A9273E@ExchMailbox2.univ.dir.wwu.edu
Список
Дерево обсуждения
restore a table in a database Marc Fromm <Marc.Fromm@wwu.edu>
Re: restore a table in a database val <valiouk@yahoo.co.uk>
Re: restore a table in a database Marc Fromm <Marc.Fromm@wwu.edu>

How do I restore just a table to a database? I was able to create a backup of the required table from a backup of the database as follows.

I don’t know how to properly restore the backed up table “departments” to the original “sms” database.

 

create a new db

createdb -U postgres smstest

 

restore a backup of the db to the new db

psql -U postgres smstest < /tmp/postgresql-sms-11-24-2008_04-05-database

 

backup up the specific table from the restored db

pg_dump -U postgres -a -t departments smstest > /tmp/smsdepartments

 

The table backup is smsdepartments. How do I restore smsdepartments to the table called departments in the sms database?

 

Thanks

 

Marc

 

В списке pgsql-admin по дате отправления
От: Fabricio
Дата:
Сообщение: Re: User info?
От: Vladimir Rusinov
Дата:
Сообщение: slow slow query log
FAQ