top of page
logo-cerebrosql

POSTGRES_LIST table

The table stores information necessary to connect to PostgreSQL databases.

CREATE TABLE POSTGRES_LIST (
   [id]         INTEGER PRIMARY KEY AUTOINCREMENT,
   [alias]      TEXT,
   [groupname]  TEXT,
   [servername] TEXT,
   [serverport] TEXT,
   [dbname]     TEXT,
   [username]   TEXT,
   [userpasswd] TEXT,
   [charset]    TEXT,
   unique ([alias])
)

Description of table fields

id
sequence number of the record
alias
connection alias
groupname
group name (used to group entries in the connection manager)
servername
server name
serverport
port number
dbname
database name
username
user name
userpasswd
password user
charset
connection encoding
vlib
path to libpg.lib library
bottom of page