PostgreSQL Native Interface

Interact with a PostgreSQL database using the PostgreSQL native interface

Create a data source and connect to a PostgreSQL database. Explore data and import data from the database into MATLAB^®. Export data from MATLAB into the database. Explore and import data using the Database Explorer app or the command line.

Objects

`connection`	PostgreSQL native interface database connection (Since R2020b)
`SQLConnectionOptions`	Define PostgreSQL native interface database connection options (Since R2020b)

Functions

expand all

PostgreSQL Native Interface Configuration

`databaseConnectionOptions`	Create database connection options (Since R2020b)
`rmoptions`	Remove PostgreSQL native interface connection options (Since R2020b)
`saveAsDataSource`	Save PostgreSQL native interface data source (Since R2020b)
`setoptions`	Set PostgreSQL native interface connection options (Since R2020b)
`reset`	Reset PostgreSQL native interface connection options to defaults (Since R2020b)
`testConnection`	Test PostgreSQL native interface database connection (Since R2020b)

PostgreSQL Native Interface Connection

`postgresql`	Create PostgreSQL native interface database connection (Since R2020b)
`close`	Close PostgreSQL native interface database connection (Since R2020b)
`isopen`	Determine if PostgreSQL native interface database connection is open (Since R2020b)
`sqlfind`	Find information about all table types in PostgreSQL database (Since R2020b)

Import Data into MATLAB

`fetch`	Import results of SQL statement in PostgreSQL database into MATLAB (Since R2020b)
`sqlread`	Import data into MATLAB from PostgreSQL database table (Since R2020b)
`sqlinnerjoin`	Inner join between two PostgreSQL database tables (Since R2020b)
`sqlouterjoin`	Outer join between two PostgreSQL database tables (Since R2020b)
`executeSQLScript`	Execute SQL script on PostgreSQL database (Since R2020b)

Customize Options for Data Import from Database

`databaseImportOptions`	Define import options for database data
`getoptions`	Retrieve import options for database data
`preview`	Preview eight rows from database using import options
`setoptions`	Customize import options for database data
`reset`	Reset to default import options for database data

Import Large Data into MATLAB

`databaseDatastore`	Datastore for data in database
`hasdata`	Determine if data in `DatabaseDatastore` is available to read
`preview`	Return subset of data from `DatabaseDatastore`
`read`	Read data in `DatabaseDatastore`
`readall`	Read all data in `DatabaseDatastore`
`reset`	Reset `DatabaseDatastore` to initial state
`splitsqlquery`	Split SQL query using paging
`createConnectionForPool`	Initialize parallel pool using database connection

Export Data from MATLAB

sqlwrite Insert MATLAB data into PostgreSQL database table (Since R2020b)

Database Operations

`execute`	Execute SQL statement using PostgreSQL native interface database connection (Since R2020b)
`commit`	Make changes to PostgreSQL database permanent (Since R2020b)
`rollback`	Undo changes to PostgreSQL database (Since R2020b)
`sqlupdate`	Update rows in PostgreSQL database table (Since R2023a)

Topics

Configure PostgreSQL Native Interface

Configure PostgreSQL Native Interface Data Source
Configure a PostgreSQL native interface data source for a PostgreSQL database on Windows^®.

Import Data into MATLAB

Import Data from PostgreSQL Database Table
Import data from one table in a PostgreSQL database by using various functions.
Customize Options for Importing Data from PostgreSQL Database into MATLAB
Customize import options for multiple variables when importing data from a database.
Import Large PostgreSQL Data Using DatabaseDatastore Object
Create a DatabaseDatastore object for accessing collections of data stored in a PostgreSQL database.

Export Data from MATLAB

Insert Data into Database Table Using PostgreSQL Native Interface
Perform calculations on data and insert the results into a PostgreSQL database using the sqlwrite function.

Execute Database Operations

Create Table and Add Column Using PostgreSQL Native Interface
Manage database structures using the CREATE and ALTER SQL statements in a PostgreSQL database.
Delete Data from Database Using PostgreSQL Native Interface
Delete data from a PostgreSQL database using the SQL DELETE statement.
Roll Back Data in Database Using PostgreSQL Native Interface
Roll back data after inserting data into a table in a PostgreSQL database.

Deploy Standalone Database Application

Deploy PostgreSQL Native Interface Database Application with MATLAB Compiler
Write a MATLAB script that connects to a PostgreSQL database, and deploy the script as a standalone database application to other machines.