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:
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
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.
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”…
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 по дате отправления: