babelfishpg_common

Overview

special case: this extension only works on wiltondb kernel fork

Version

Build

You can build the RPM / DEB packages for babelfish using pig build:

pig build pkg babelfish         # build RPM / DEB packages

Install

You can install babelfish directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

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

Install the extension using pig or apt/yum/dnf:

pig install babelfish;          # Install for current active PG version

pig ext install -y babelfish -v 18  # PG 18
pig ext install -y babelfish -v 17  # PG 17

dnf install -y babelfish-18       # PG 18
dnf install -y babelfish-17       # PG 17

apt install -y babelfish-18   # PG 18
apt install -y babelfish-17   # PG 17

Create Extension:

CREATE EXTENSION babelfishpg_common;

Usage

babelfishpg_common: SQL Server Transact SQL Datatype Support

The babelfishpg_common extension provides SQL Server-compatible data type support for PostgreSQL as part of the Babelfish project. It enables PostgreSQL to understand and work with Microsoft SQL Server data types.

Enabling

CREATE EXTENSION babelfishpg_common;

SQL Server Data Types

The extension adds the following SQL Server-compatible data types:

• TINYINT - 1-byte unsigned integer (0 to 255)
• SMALLMONEY - Small monetary value
• MONEY - Monetary value (see also babelfishpg_money)
• DATETIME - SQL Server-style datetime
• DATETIME2 - Extended precision datetime
• SMALLDATETIME - Reduced precision datetime
• DATETIMEOFFSET - Date and time with timezone offset
• BIT - SQL Server-compatible boolean
• NCHAR / NVARCHAR - Unicode character types
• UNIQUEIDENTIFIER - SQL Server-style UUID
• VARBINARY - Variable-length binary data
• IMAGE - Legacy binary data type
• SQL_VARIANT - Generic data type container
• XML - SQL Server-compatible XML type
• SYSNAME - System name type (nvarchar(128))

Key Features

• Provides implicit and explicit type casting between SQL Server and PostgreSQL types
• Supports SQL Server-style collation behavior
• Handles SQL Server-specific type coercion rules
• Works in conjunction with babelfishpg_tsql for full T-SQL compatibility

This extension is typically deployed as part of a full Babelfish for PostgreSQL installation and is a prerequisite for babelfishpg_tsql.