babelfishpg_tds

babelfish : SQL Server TDS protocol extension

Overview

ID	Extension	Package	Version	Category	License	Language
9320	babelfishpg_tds	babelfish	`1.0.0`	SIM	Apache-2.0	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--sLd-r	No	Yes	Yes	Yes	yes	no

Relationships
Requires	babelfishpg_tsql
See Also	tds_fdw babelfishpg_common babelfishpg_money pg_hint_plan uuid-ossp session_variable jdbc_fdw db_migrator
Siblings	babelfishpg_common babelfishpg_tsql babelfishpg_money

special case: this extension only works on wiltondb kernel fork

Packages

Type	Repo	Version	PG Major Compatibility	Package Pattern	Dependencies
EXT	PIGSTY	`1.0.0`	18 17 16 15 14	`babelfish`	`babelfishpg_tsql`
RPM	PIGSTY	`1.0.0`	18 17 16 15 14	`babelfish_$v`	`babelfishpg_$v`, `antlr4-runtime413`
DEB	PIGSTY	`1.0.0`	18 17 16 15 14	`babelfishpg-$v-babelfish`	`babelfishpg-$v`, `libantlr4-runtime413`

Linux / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	MISS	PIGSTY 5.5.0	MISS	MISS	MISS
el8.aarch64	MISS	PIGSTY 5.5.0	MISS	MISS	MISS
el9.x86_64	MISS	PIGSTY 5.5.0	MISS	MISS	MISS
el9.aarch64	MISS	PIGSTY 5.5.0	MISS	MISS	MISS
el10.x86_64	MISS	PIGSTY 5.5.0	MISS	MISS	MISS
el10.aarch64	MISS	PIGSTY 5.5.0	MISS	MISS	MISS
d12.x86_64	MISS	PIGSTY 5.5.0	MISS	MISS	MISS
d12.aarch64	MISS	PIGSTY 5.5.0	MISS	MISS	MISS
d13.x86_64	MISS	PIGSTY 5.5.0	MISS	MISS	MISS
d13.aarch64	MISS	PIGSTY 5.5.0	MISS	MISS	MISS
u22.x86_64	MISS	PIGSTY 5.5.0	MISS	MISS	MISS
u22.aarch64	MISS	PIGSTY 5.5.0	MISS	MISS	MISS
u24.x86_64	MISS	PIGSTY 5.5.0	MISS	MISS	MISS
u24.aarch64	MISS	PIGSTY 5.5.0	MISS	MISS	MISS

Source

Repository

babelfishpg.org/

Source Tarball

babelfishpg-17.8-5.5.0.tar.gz

pig build pkg babelfish;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

pig install babelfish;		# install via package name, for the active PG version
pig install babelfishpg_tds;		# install by extension name, for the current active PG version

pig install babelfishpg_tds -v 17;   # install for PG 17

Config this extension to shared_preload_libraries:

shared_preload_libraries = 'babelfishpg_tds';

Create this extension with:

CREATE EXTENSION babelfishpg_tds CASCADE; -- requires babelfishpg_tsql

Usage

Install go-sqlcmd:

curl -LO https://github.com/microsoft/go-sqlcmd/releases/download/v1.4.0/sqlcmd-v1.4.0-linux-amd64.tar.bz2
tar xjvf sqlcmd-v1.4.0-linux-amd64.tar.bz2
sudo mv sqlcmd* /usr/bin/

Try go-sqlcmd

$ sqlcmd -S 10.10.10.10,1433 -U dbuser_mssql -P DBUser.MSSQL
1> select @@version
2> go
version                                                                                                                                                                                                                                                         
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Babelfish for PostgreSQL with SQL Server Compatibility - 12.0.2000.8
Oct 22 2023 17:48:32
Copyright (c) Amazon Web Services
PostgreSQL 15.4 (EL 1:15.4.wiltondb3.3_2-2.el8) on x86_64-redhat-linux-gnu (Babelfish 3.3.0)                                        

(1 row affected)

Access pigsty exposed primary/replica service port

sqlcmd -S 10.10.10.11,5433 -U dbuser_mssql -P DBUser.MSSQL

sqlcmd -S 10.10.10.11,5434 -U dbuser_mssql -P DBUser.MSSQL

Last updated on 2026-03-04

babelfishpg_tsql babelfishpg_money