User`s guide

2 Getting Started with Database Toolbox

2-158

Connect to PostgreSQL using the JDBC connection command line.

When using the command line, you do not have to set up a data source with Database

Explorer. You can use the command line to pass all the required parameters for

connection.

Use the Vendor name-value pair argument of database to specify a connection to a

PostgreSQL database. For example, the following code assumes you are connecting

to a database named dbname on a database server named sname with user name

username and password pwd.

conn = database('dbname','username','pwd',...

'Vendor','PostgreSQL',...

'Server','sname');

Close the database connection conn.

close(conn)