Re: Database Import..Please Help Me - Mailing list pgsql-admin

From Steve Crawford
Subject Re: Database Import..Please Help Me
Date
Msg-id 4A37BE8C.8030802@pinpointresearch.com
Whole thread Raw
In response to Database Import..Please Help Me  ("Premila Devi" <premiladevi.dayalan@agbnielsen.com>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable
Next
From: Andy Shellam
Date:
Subject: Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable