Skip to content

Instantly share code, notes, and snippets.

@ohvitorino
Last active August 29, 2015 14:14
Show Gist options
  • Save ohvitorino/db0e954d334db79f9f82 to your computer and use it in GitHub Desktop.
Save ohvitorino/db0e954d334db79f9f82 to your computer and use it in GitHub Desktop.
PostgreSQL: freetds foreign data wrapper
apt-get install freetds-dev
apt-get install libsybdb5 freetds-dev freetds-common
apt-get install postgresql-server-dev-9.3
apt-get install git
git clone https://github.com/GeoffMontee/tds_fdw.git
cd tds_fdw/
apt-get install build-essential
PATH=/usr/lib/postgresql/9.3/bin/:$PATH USE_PGXS=1 make
PATH=/usr/lib/postgresql/9.3/bin/:$PATH USE_PGXS=1 make install
service postgresql restart
vim /etc/freetds/freetds.conf
su - postgres
vim /etc/odbc.ini
vim /etc/odbcinst.ini
apt-get install sqsh
sqsh -S mssql_freetds -U anyone
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment