Обсуждение: Database Import..Please Help Me

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

Database Import..Please Help Me

От
"Premila Devi"
Дата:

 

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”…

 

Could you please help me...?

 

I am trying to Import the File But cannot…

 

Herewith I attach the “Database”….to ease your understanding...

 

Please help me...

 

Thank you

 

Warmest Regards,

Premila Devi Dayalan Ramasamy
Programmer Analyst
MSAP Production Development

AGB Nielsen Media Research
Level 7,Block B,Menara PKNS-PJ,Jalan Yong Shook Lin , 46050 Petaling Jaya , Selangor
( Malaysia )

t: 603-7620 2320
f: 603-7620 2316

Please note:
This email transmission including its attachments, are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any views or opinions are solely those of the author and do not necessarily represent those of AGB Nielsen Media Research, unless specifically stated. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this email in error, please contact the sender and delete the email transmission immediately.

 

Вложения

Re: Database Import..Please Help Me

От
Steve Crawford
Дата:
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