Обсуждение: DB Export and Import in PGSQL

Поиск
Список
Период
Сортировка

DB Export and Import in PGSQL

От
spraveen2001@yahoo.com (Praveen)
Дата:
Hi All,

I'm using PGSql 7.4.3 on win2k system. i have a small db with some
tables,indexes,sequences,constraints and data. Today i took the
export(pg_dump) of my db and try to import(psql) in different new
database.
The following command i used:
psql mydb < mybackfile.bkp

It is successfully able to import table,sequence,indexes,constraints
but data is not able to import. means, i'm not able to see my data.

Can anyone tell what might be the problem?

Thanks,
Praveen