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.
connection | PostgreSQL native interface database connection |
SQLConnectionOptions | Define PostgreSQL native interface database connection options |
Configure PostgreSQL Native Interface Data Source
Configure a PostgreSQL native interface data source to a PostgreSQL database on Windows®.
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.
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.
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 an 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 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.