Postgres Notes

Postgres Documentation

pgAdmin - GUI administration tool for Postgres

Postgres has a binary windows installer package, which includes pgAdmin

There is a system path warning for conflicts with Cygwin; if Cygwin is installed, some dll's won't mix well

Installed as a service on Win32, creating a user'postgres' with a randomly generated password

port 5432, checked box to accept connections from all hosts

pgAdmin has a tips file at 'pgadmin III/docs/en_US/tips.txt'

database encoding warning - default database encoding is SQL_ASCII, but many files are UTF8 or other ecoding; make sure to specify an encoding with the createdb commands below

EMS SQL Manager Lite is free - available for MySQL, Postgres, SQL Server, Oracle

Postgres on the Mac: http://developer.apple.com/internet/opensource/postgres.html

backticks (`) don't work in Postgres (commonly used in MySQL)

common primary key type in MySQL: “int(11) NOT NULL auto_increment” in Postgres is “serial”, and a sequence is automatically created for the increment

type blob is bytea in Postgres

in expressions, _ (underscore) matches any single character, and % (percent) matches any string of zero or more characters

escapes and string constants are covered in section 4.1.2.1 of the Postgres documentation; to escape a single quote, precede it with another: ''