Import different format data into adempiere database

CSV or other file format data import to Adempiere database. Steps are bellow

Step1.

copy adempiere.C_Location_test from '/opt/PostgreSQL/8.4/C_Location.txt' delimiters ',' csv;

Description: 

adempiere: is schema,  

    C_Location_test: is table name. 

    '/opt/PostgreSQL/8.4/C_Location.txt' : location where csv, txt and other file format is located.

Step2:

truncate table adempiere.m_product cascade;   

Description:

This query is used to delete all record from all table which containing m_product_id of m_product table