mysql fdw_PostgreSQL通过mysql_fdw访问MySQL数据库

[root@server mysql_fdw-1.0.1]# catREADME

MySQL FDWfor PostgreSQL 9.1+

==============================This PostgreSQL extension implements a Foreign Data Wrapper (FDW)forthe MySQL.

This code is experimental, and largely intended as a pet projectforme

to experiment with and learn about FDWsinPostgreSQL.

By all means use it, butdo so entirely at your own risk!You have been

warned!Building--------Install MySQL, or just the C client library, and Once that's done, the

extension can be built with:

PATH=/usr/local/pgsql/bin/:/usr/local/mysql/bin:$PATH make USE_PGXS=1

sudo PATH=/usr/local/pgsql/bin/:/usr/local/mysql/bin:$PATH make USE_PGXS=1 install(assuming you have PostgreSQL9.1 in /usr/local/pgsql and MySQL in

/usr/local/mysql).

I've tested on Mac OS X 10.7 only, but other *nix's should also work.

I haven't tested on Windows, but the code should be good on MinGW.

Limitations-----------

-No attempt is made to pushdown quals to MySQL.- The MySQL connection used to plan queries isn't currently reused

during execution.

Usage-----The following parameters can be set on a MySQL foreign server:

address: The address orhostnameof the MySQL server.

Default:127.0.0.1port: The port number onwhichthe MySQL server is listening.

Default:3306The following parameter can be set on a MySQL foreign table:

database: The name of the MySQL database to query.

Default: NULL

query: An SQL query to define the data set on the MySQL server.

table: The name of a table (quoted and qualified as required)

on the MySQL table.

Note that the query and table paramters are mutually exclusive. Using

query can provide either a simple way to push down quals (whichof

course is fixed at definitiontime), or to base remote tables onmorecomplex SQL queries.

The following parameter can be set on a user mappingfora MySQL

foreign server:

username: The username to use when connecting to MySQL

Defaultpassword: The password to authenticate to the MySQL server with.

Default:Example-------

--Install the extension

CREATE EXTENSION mysql_fdw;--Create the foreign server, a pointer to the MySQL server.

CREATE SERVER mysql_svr

FOREIGN DATA WRAPPER mysql_fdw

OPTIONS (address'127.0.0.1', port '3306');-- Create one or moreforeign tables on the MySQL server. The first of--these maps to a remote table, whilst the second uses an SQL query.

CREATE FOREIGN TABLE employees (idinteger,

name text,

address text)

SERVER mysql_svr

OPTIONS (table'hr.employees');

CREATE FOREIGN TABLE overtime_2010 (idinteger,

employee_id integer,

hours integer)

SERVER mysql_svr

OPTIONS (query'SELECT id, employee_id, hours FROM hr.overtime WHERE year = 2010;');-- Create a user mapping to tell the FDW the username/password to-- use to connect to MySQL, for PUBLIC. This could be done on a per-

--role basis.

CREATE USER MAPPING FOR PUBLIC

SERVER mysql_svr

OPTIONS (username'dpage', password '');--Dave Page

dpage@pgadmin.org

[root@server mysql_fdw-1.0.1]#