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@xxxxxxxxxxxxxx) > 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! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
