I've done similar things with a plpythonu function.
Basically, import the mysql module, call your select statement and then
for each row do a plpy.execute(insert stmt)
Sim
On 07/05/2011 12:10 AM, Jonathan Brinkman wrote:
Greetings
I'd like to INSERT data into my Postgresql 8.4.8 table
Guys, the OP isn't using MySQL, but MS-SQL.
Not that your solutions don't apply in that case, but it's just a little sloppy
to be talking about the wrong database all the time ;)
On 5 Jul 2011, at 9:37, Sim Zacks wrote:
I've done similar things with a plpythonu function.
Basically, import
MySQL for anything.
Thanks much for your response!
J
From: Brent Wood [mailto:b.w...@niwa.co.nz]
Sent: Monday, July 04, 2011 8:58 PM
To: j...@blackskytech.com
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Read MS-SQL data into Postgres via ODBC link?
Hi Jonathan,
I haven't
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jonathan Brinkman
Sent: Tuesday, July 05, 2011 7:48 AM
To: pgsql-general@postgresql.org
Cc: 'Brent Wood'
Subject: Re: [GENERAL] Read MS-SQL data into Postgres via ODBC link?
Thanks
I'm importing
On 5 Jul 2011, at 23:27, Susan Cassidy wrote:
Thanks
I’m importing into Postgresql 8.4.8 from MSSQL 2005.
I do not have control over the MSSQL server, it is at a customer’s site. I
only have access to read-only views on their server, from which I replicate
the data to my postgres
'
Subject: Re: [GENERAL] Read MS-SQL data into Postgres via ODBC link?
On 5 Jul 2011, at 23:27, Susan Cassidy wrote:
Thanks
I'm importing into Postgresql 8.4.8 from MSSQL 2005.
I do not have control over the MSSQL server, it is at a customer's site.
I only have access to read-only views
On Tue, 5 Jul 2011 19:38:25 -0400
Jonathan Brinkman j...@blackskytech.com wrote:
I was really hoping to keep the data-replication (between MSSQL
-- PG) contained within a PG function.
Instead I could write a small shell script or C service to do this
using tsql (freetds). I have access to
Greetings
I'd like to INSERT data into my Postgresql 8.4.8 table directly from an
ODBC-linked MS-SQL table or view.
I'm looking at using the Cybertec tool ODBC-LINK
(http://www.cybertec.at/en/postgresql_products/odbc-link) but I'm wondering
if there isn't a way to do this through Postgresql
Hi Jonathan,
I haven't done this from MySQL, but have from Postgres from Oracle
From a command line client, extract the data from the source table, so you get
a stream of csv style records.
Then pipe these directly into a psql statement to load them into the target
table.
A simple pg2pg