Personal tools
You are here: Home downloads psql
Document Actions

psql

RSS Feed Category: Libraries and externals — Other products by this author
allows you to send SQL messages to a PostgreSQL database from Pd and retrieve the results

Current release

No stable release available yet.

If you are interested in getting the source code of this project, you can get it from the code repository.

Experimental releases

There are no experimental releases available at the moment.

Project Description

Project resources

'psql' allows you to send SQL messages to a PostgreSQL database from Pd and retrieve the results. In order to use the 'psql' external you will need to install PostgreSQL - available from http://www.postgresql.org. As with all applications that connect to a PostgreSQL database, 'psql' requires the 'postmaster' daemon to be running.
'psql' may connect to a database on a local host or on a remote machine via TCP/IP (handled by the external).

If no arguments are specified in 'psql' - messages will be sent to a postmaster via a local UNIX socket and will attempt to connect to the default PostgreSQL 'template1' database. Such a connection may be used to create new database by sending the SQL message: 'CREATE DATABASE databasename'. Before this can be done, you will need to set your username as a PostgreSQL user. This can be done from a PostgreSQL superuser account (not root) generally called 'postgres' which handles database administrative duties including access privileges.

by Jamie Bullock last modified 2012-12-08 03:40 AM

Powered by IEM Powered by Plone Section 508 WCAG Valid XHTML Valid CSS Usable in any browser