Подключение к источнику данных PostgreSQL (мастер импорта и экспорта SQL Server) Connect to a PostgreSQL Data Source (SQL Server Import and Export Wizard)
Применимо к: Applies to: SQL Server SQL Server (все поддерживаемые версии) SQL Server SQL Server (all supported versions) Azure-SSIS Integration Runtime в Фабрике данных Azure SSIS Integration Runtime in Azure Data Factory Azure-SSIS Integration Runtime в Фабрике данных Azure SSIS Integration Runtime in Azure Data Factory Применимо к: Applies to: SQL Server SQL Server (все поддерживаемые версии) SQL Server SQL Server (all supported versions) Azure-SSIS Integration Runtime в Фабрике данных Azure SSIS Integration Runtime in Azure Data Factory Azure-SSIS Integration Runtime в Фабрике данных Azure SSIS Integration Runtime in Azure Data Factory
В этом разделе показано, как подключаться к источникам данных PostgreSQL со страницы Выбор источника данных или Выбор назначения в мастере импорта и экспорта SQL Server. This topic shows you how to connect to a PostgreSQL data source from the Choose a Data Source or Choose a Destination page of the SQL Server Import and Export Wizard.
Подробные требования и необходимые условия для подключения к базе данных PostgreSQL выходят за рамки этой статьи Майкрософт. The detailed requirements and prerequisites for connecting to a PostgreSQL database are beyond the scope of this Microsoft article. В ней предполагается, что у вас уже установлено клиентское программное обеспечение PostgreSQL и вы можете успешно подключиться к целевой базе данных PostgreSQL. This article assumes that you already have PostgreSQL client software installed and that you can already connect successfully to the target PostgreSQL database. Для получения дополнительных сведений обратитесь к администратору базы данных PostgreSQL или к документации по PostgreSQL. For more info, consult your PostgreSQL database administrator or the PostgreSQL documentation.
Получение драйвера ODBC для PostgreSQL Get the PostgreSQL ODBC driver
Установка драйвера ODBC с помощью построителя стека Install the ODBC driver with Stack Builder
Запустите построитель стека, чтобы добавить драйвер ODBC для PostgreSQL (psqlODBC) в вашу установку PostgreSQL. Run Stack Builder to add the PostgreSQL ODBC driver (psqlODBC) to your installation of PostgreSQL.
Скачивание последней версии драйвера ODBC Or, download the latest ODBC driver
Или скачайте установщик Windows для последней версии драйвера ODBC для PostgreSQL (psqlODBC) прямо с этого FTP-сайта — https://www.postgresql.org/ftp/odbc/versions/msi/. Or, download the Windows installer for the latest version of the PostgreSQL ODBC driver (psqlODBC) directly from this FTP site — https://www.postgresql.org/ftp/odbc/versions/msi/. Извлеките содержимое ZIP-файла и запустите файл MSI. Extract the files from the .zip file and run the .msi file.
Подключение к PostgreSQL с помощью драйвера ODBC для PostgreSQL (psqlODBC) Connect to PostgreSQL with the PostgreSQL ODBC driver (psqlODBC)
Драйверы ODBC не приводятся в раскрывающемся списке источников данных. ODBC drivers aren’t listed in the drop-down list of data sources. Чтобы подключиться с помощью драйвера ODBC, сначала выберите поставщик данных .NET Framework для ODBC в качестве источника данных на странице Выбор источника данных или Выбор назначения. To connect with an ODBC driver, start by selecting the .NET Framework Data Provider for ODBC as the data source on the Choose a Data Source or Choose a Destination page. Этот поставщик служит оболочкой для драйвера ODBC. This provider acts as a wrapper around the ODBC driver.
Ниже показан экран, который появляется сразу после выбора поставщика данных .NET Framework для ODBC. Here’s the generic screen that you see immediately after selecting the .NET Framework Data Provider for ODBC.
Указываемые параметры (драйвер ODBC для PostgreSQL) Options to specify (PostgreSQL ODBC driver)
Параметры подключения для этого поставщика данных и драйвера ODBC одинаковы независимо от того, является ли PostgreSQL источником или назначением. The connection options for this data provider and ODBC driver are the same whether PostgreSQL is your source or your destination. Таким образом, на страницах Выбор источника данных и Выбор назначения мастера отображаются одинаковые параметры. That is, the options you see are the same on both the Choose a Data Source and the Choose a Destination pages of the wizard.
Чтобы подключиться к PostgreSQL с помощью драйвера ODBC для PostgreSQL, соберите строку подключения, используя указанные ниже параметры и их значения. To connect to PostgreSQL with the PostgreSQL ODBC driver, assemble a connection string that includes the following settings and their values. Полный формат строки подключения приведен после списка параметров. The format of a complete connection string immediately follows the list of settings.
Вы можете получить помощь в построении строки подключения. Get help assembling a connection string that’s just right. Кроме того, вместо указания строки подключения вы можете предоставить существующее имя DSN (имя источника данных) или создать новое. Or, instead of providing a connection string, provide an existing DSN (data source name) or create a new one. Дополнительные сведения об этих возможностях см. в разделе Подключение к источнику данных ODBC. For more info about these options, see Connect to an ODBC Data Source.
Драйвер Driver
Имя драйвера ODBC — PostgreSQL ODBC Driver(UNICODE) или PostgreSQL ODBC Driver(ANSI). The name of the ODBC driver — either PostgreSQL ODBC Driver(UNICODE) or PostgreSQL ODBC Driver(ANSI).
Server Server
Имя сервера PostgreSQL. The name of the PostgreSQL server.
порт. Port
Порт, используемый для подключения к серверу PostgreSQL. The port to use to connect to the PostgreSQL server.
База данных Database
Имя базы данных PostgreSQL. The name of the PostgreSQL database.
Uid и Pwd Uid and Pwd
Uid (идентификатор пользователя) и Pwd (пароль) для подключения. The Uid (user id) and Pwd (password) to connect.
Формат строки подключения Connection string format
Ниже приведен формат типичной строки подключения. Here’s the format of a typical connection string.
Ввод строки подключения Enter the connection string
Введите строку подключения в поле ConnectionString либо введите имя DSN в поле Dsn на странице Выбор источника данных или Выбор назначения. Enter the connection string in the ConnectionString field, or enter the DSN name in the Dsn field, on the Choose a Data Source or Choose a Destination page. После того как вы введете строку подключения, мастер проанализирует ее и отобразит отдельные свойства и их значения в списке. After you enter the connection string, the wizard parses the string and displays the individual properties and their values in the list.
В приведенном ниже примере используется следующая строка подключения: The following example uses this connection string.
Ниже показан экран, который появляется после ввода строки подключения. Here’s the screen that you see after entering the connection string.
Другие поставщики данных и дополнительные сведения Other data providers and more info
Сведения о подключении к PostgreSQL с помощью поставщика данных, не представленного в этом списке, см. в разделе Строки подключения PostgreSQL. For info about how to connect to PostgreSQL with a data provider that’s not listed here, see PostgreSQL connection strings. Этот сторонний сайт также содержит дополнительные сведения о поставщиках данных и параметрах подключения, описанных на этой странице. This third-party site also contains more info about the data providers and the connection parameters described on this page.
Windows installers 
Interactive installer by EDB
Download the installer certified by EDB for all supported PostgreSQL versions.
This installer includes the PostgreSQL server, pgAdmin; a graphical tool for managing and developing your databases, and StackBuilder; a package manager that can be used to download and install additional PostgreSQL tools and drivers. Stackbuilder includes management, integration, migration, replication, geospatial, connectors and other tools.
This installer can run in graphical or silent install modes.
The installer is designed to be a straightforward, fast way to get up and running with PostgreSQL on Windows.
Advanced users can also download a zip archive of the binaries, without the installer. This download is intended for users who wish to include PostgreSQL as part of another application installer.
Platform support
The installers are tested by EDB on the following platforms. They can generally be expected to run on other comparable versions:
| PostgreSQL Version | 64 Bit Windows Platforms | 32 Bit Windows Platforms |
|---|---|---|
| 13 | 2019, 2016 | |
| 12 | 2019, 2016, 2012 R2 | |
| 11 | 2019, 2016, 2012 R2 | |
| 10 | 2016, 2012 R2 & R1, 7, 8, 10 | 2008 R1, 7, 8, 10 |
| 9.6 | 2012 R2 & R1, 2008 R2, 7, 8, 10 | 2008 R1, 7, 8, 10 |
| 9.5 | 2012 R2 & R1, 2008 R2 | 2008 R1 |
Copyright © 1996-2020 The PostgreSQL Global Development Group
Software Catalogue — Drivers and interfaces
27 product(s) were found in this category.
AspSQLProvider
AspSQLProvider is a PostgreSQL implementation of the ASP.NET 2.0 Membership, Role, Profile and Session-State Store Provider.
DBD::Pg
PostgreSQL database driver for the Perl DBI module
dbExpress driver for PostgreSQL
dbExpress Driver for PostgreSQL is a database-independent layer that defines common interface to provide fast access to PostgreSQL from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms. For this server, dbExpress provides a driver as an independent library that implements the common dbExpress interface for processing queries and stored procedures.
As data-access layer is thin and simple, dbExpress provides high performance database connectivity and is easy to deploy. You can use dbExpress driver for PostgreSQL in the same way as the one supplied by Embarcadero.
Direct Mode
Allows your application to work with PostgreSQL directly without involving PostgreSQL connectivity solutions, thus significantly facilitating deployment and configuration of your applications.
DB Compatibility
Our product supports the latest PostgreSQL server versions up to 11. We also provide compatibility with Microsoft Azure Database for PostgreSQL and Google Cloud for PostgreSQL.
IDE Compatibility
Our product is compatible with the latest IDE versions and editions including Community Edition: Embarcadero RAD Studio 10.3 Rio, Delphi 10.3 Rio and C++Builder 10.3 Rio. It is also compatible with the previous IDE versions since Delphi 6 and C++Builder 6.
Learn more about dbExpress Driver for PostgreSQL on Devart website.
dotConnect for PostgreSQL
dotConnect for PostgreSQL is an enhanced database connectivity solution built over ADO.NET architecture and a development framework with a number of innovative technologies.
With state of the art ORM solutions such as Entity Framework and LINQ to SQL, it introduces new approaches for designing applications and boosts productivity of database application development.
Key Features
Database Application Development Extensions. dotConnect for PostgreSQL has a rich set of design time tools that leverage the development process greatly. Particularly, there are convenient component editors, wizards and managers, toolset for live data binding, DDEX, a and much more.
PostgreSQL Advanced Features Support. dotConnect for PostgreSQL allows developers to harness full capabilities of the PostgreSQL server. dotConnect for PostgreSQL supports such PostgreSQL-specific features as secure SSL connections, PostgreSQL notifications, PostgreSQL bulk data loading and others.
Optimized Code. dotConnect for PostgreSQL assemblies are implemented using optimized code and advanced data access algorithms.
ORM Support. dotConnect for PostgreSQL offers enhanced ORM support with a bundled visual designer for ORM models — Entity Developer. dotConnect for PostgreSQL supports Entity Framework v1-v6.3, NHibernate, and LinqConnect (formerly LINQ to PostgreSQL) — our own ORM solution, closely compatible to Microsoft LINQ to SQL, while extending its functionality with its own features.
Framework Compatibility. The provider works with .NET Framework 2.x-4.8, .NET Core 1.x-3.0, .NET Compact Framework 2.0 and above, Mono version 2.0 and above
Excel Add-in for PostgreSQL
Devart Excel Add-in for PostgreSQL allows you to quickly and easily connect Microsoft Excel to PostgreSQL, load data from PostgreSQL to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to PostgreSQL.
It enables you to work with PostgreSQL data like with usual Excel worksheets, easily perform data cleansing and de-duplication, and apply all the Excel’s powerful data processing and analysis capabilities to these data.
Connect to PostgreSQL Directly from Excel
To connect Excel to PostgreSQL you just need to specify its host, port, and your credentials. As for security, PostgreSQL Excel Add-in supports secure SSL connections, secure authentication with single sign-on, etc.
Use Query Builder or SQL to Import Data You Need
Visual Query Builder allows you to choose a table to import data from, select the columns from this table and related tables, and set filter conditions and data ordering options visually. If you need to select data more precisely, you can use SQL to select data you need.
Instantly Refresh Data Whenever You Need
It’s very convenient to always have fresh data from the database right in your workbook. Imagine, you have performed data analysis in your Excel workbook, built some charts for your PostgreSQL data, and you can re-read data from the source and update all this to the current state by just clicking a button on the ribbon whenever you need.
Instant Data Validation
Excel Add-in for PostgreSQL instantly validates entered data and highlights errors, such as incorrect dates, duplicate primary key values, etc.
Learn more about Excel add-in for PostgreSQL on Devart website.
libpqxx
libpqxx is the official C++ client API for PostgreSQL, the enterprise-strength open-source database software.
LinqConnect
LinqConnect is a fast, lightweight, and easy to use LINQ to SQL compatible ORM solution, supporting PostgreSQL, SQL Server, Oracle, MySQL and SQLite. It allows using efficient and powerful data access for your .NET Framework, Metro, Silverlight, or Windows Phone applications supporting Code-First, Model-First, Database-First or mixed approaches.
Lua binding for PostgreSQL
Access your PostgreSQL data from the Lua programming language. luapgsql is a libpq binding for Lua.
Npgsql
Npgsql is a .Net data provider for PostgreSQL. It allows any program developed for .Net framework to access database server. It is implemented in 100% C# code. Works with PostgreSQL 7.x and 8.x.
ODBC for PostgreSQL
Devart ODBC Driver for PostgreSQL provides high-performance and feature-rich connectivity solution for ODBC-based applications to access PostgreSQL databases from Windows, Linux, MacOS, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your database applications with PostgreSQL fast, easy and extremely handy.
Direct Connection
Database applications based on our solution get an opportunity to establish a connection to PostgreSQL directly. Direct Connection gives your applications an unrivalled advantage — connection to PostgreSQL databases directly via TCP/IP avoiding PostgreSQL Client.
Integration
The driver is compatible with 3rd-party tools for data analysis, such as Microsoft Excel, and integrates with various IDEs and systems like Visual Studio, etc.
Fully Unicode Driver
With our fully Unicode driver, you can retrieve and work with any data from multi-lingual PostgreSQL databases correctly, not depending on whether its charset is Latin, Cyrillic, Hebrew, Chinese, etc., in any environment localization.
Bulk Updates
Moreover, with our driver you can perform bulk updates to PostgreSQL database by combining SQL statements into batches, thus simplifying and speeding up large data modification to PostgreSQL.
Security
Work with PostgreSQL securely using SSL connection options provided in our driver along with the support for SSL protocol. You can also connect to PostgreSQL securely via SSH tunnel. SSH protocol is one of the most reliable protocols for data encryption.
Learn more about more ODBC for PostgreSQL features on Devart website.
A modern C++ API to PostgreSQL that simplifies working with PostgreSQL in C++.
pgintcl
This is a Tcl interface to PostgreSQL, which is itself written entirely in Tcl, and does not rely on libpq. It is highly but not entirely compatible with other Tcl interfaces, although it is slower.
pgtcl
This is a project to evolve and upgrade libpgtcl, the Tcl client interface to PostgreSQL. Application writers will be able to interface to PostgreSQL from Tcl using this interface.
pgtcl-ng
PostgreSQL Tcl Interface Next-Generation (pgtcl-ng) is a loadable Tcl/Tk module for accessing PostgreSQL databases. It extends the pre-8.0 libpgtcl from an early Pgtcl release and from the companion project pgintcl.
PostgresClientKit
PostgresClientKit provides a friendly Swift API for operating against a PostgreSQL database.
- Doesn’t require libpq
- Developer-friendly API using modern Swift
- Safe conversion between Postgres and Swift types
- Memory efficient
- SSL/TLS support