Re: Database Import..Please Help Me

Поиск
Список
Период
Сортировка
От Steve Crawford
Тема Re: Database Import..Please Help Me
Дата
Msg-id 4A37BE8C.8030802@pinpointresearch.com
обсуждение исходный текст
Ответ на Database Import..Please Help Me  ("Premila Devi" <premiladevi.dayalan@agbnielsen.com>)
Список pgsql-admin
Premila Devi wrote:

 

Good Day. I like to “Import Database” Using the postgresql-8.3.7-1-windows.

 

But, at here I did not see any “IMPORT DATABASE FEATURES”…

The file you attached is empty. We need more info. As a starting point, PostgreSQL dumps are created using pg_dump. The dump file can be a text file designed to be read back using psql or in special formats designed to be read by pg_restore. The text version is just a series of SQL statements to restore the database. The various flags to pg_dump determine the type of file created as well as things like schema-only, data-only, specific tables, etc.

If the data is not a PostgreSQL created dump, you need to do some work yourself. For example, if it is a CSV file you need a table with the correct columns and you can use psql and the copy command with the csv option.

Cheers,
Steve

В списке pgsql-admin по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable
Следующее
От: Andy Shellam
Дата:
Сообщение: Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable