From: | Rudi Starcevic <rudi(at)oasis(dot)net(dot)au> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: exporting data |
Date: | 2003-07-08 03:27:48 |
Message-ID: | 3F0A3A34.6050707@oasis.net.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2003-07-08 05:02:00 | Re: PostgreSQL settings for 12GB RAM |
Previous Message | Devi Munandar | 2003-07-08 03:02:40 | Re: exporting data |