Re: Read MS-SQL data into Postgres via ODBC link?

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 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 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 directly?
>>
>> I saw a post about someone doing a "SELECT * FROM XXX ODBC SOURCE" or
>> something like that
>> (http://archives.postgresql.org/pgsql-odbc/2009-07/msg00032.php) and that
>> would be cool. I don't need to import massive datasets, only 20-30K records
>> at a time.
>>
>> Thanks much
>>
>> Jonathan
>>
>>
>>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.

!DSPAM:737,4e133bd412094272933627!