Re: exporting data

Hi,

I've had to do this several times.
So far I've found no simple answer/way.

This is how I do it.
a) export excel file to tab seperated file.
b) Import complete csv/text file into a table using copy. ( Eg. temp_table )
c) Select from that temp table into new tables to build the new database.
Here's and example script:
INSERT INTO grounds
(
gt_id,
reg_id,
g_name,
g_address1,
g_country,
g_phone,
g_fax,
g_email,
g_url,
g_notes,
g_activities,
g_username,
g_pwd
)
SELECT
1,
1,
name,
location,
'Australia',
phone,
fax,
email_address,
domain_name,
notes,
activities,
'username',
'pwd'

FROM import_temp;

Sometimes SQL is not enough and I use scripts written in PHP or Perl or
ColdFusion.

I save all my import scripts. eg. import01.sql, import02.sql,
import03.php, so that I can easily reuse them.

Hope this brief response helps.

Cheers
Rudi.

Devi Munandar wrote:

> Dear Admin,
>
> Same Problem with Mr.Sidar Lopez Cruz too,but I want to Migration my
> data from microsoft Excel to Postgresql, there are any possible to
> Migration..???
>
> best regard,
>
> -devi munandar
>
> ----- Original Message -----
> *From:* Sidar Lopez Cruz <mailto:sidarlopez(at)hotmail(dot)com>
> *To:* pgsql-admin(at)postgresql(dot)org <mailto:pgsql-admin(at)postgresql(dot)org>
> *Sent:* Tuesday, July 08, 2003 12:44 AM
> *Subject:* [ADMIN] exporting data
>
> which is the best tool for exporting data from mssql to postgresql
> i try with pgAdmin II, but it's slow
>
> i try directly by odbc from mssql but don't work
>
>
>
> :-) Sidar Lopez Cruz
> - Cero Riesgo, S.A.
>