With AutoCommit on, a query never places a lock on a table. Readers never block writers and writers never block readers. Then a query induces a shared lock on a table and blocks anyone else until the transaction has been finished. The C statement can be used to apply an explicit lock on a table. To ensure that a table being selected does not change before you make an update later in the transaction, you must explicitly lock it with a C statement before executing the select.
Inner joins use the traditional syntax.
The max size of table and column names cannot exceed 31 charaters in length. Postgresql converts all identifiers to lower-case unless enclosed in double quotation marks. National character set characters can be used, if enclosed in quotation marks. Any number of named sequence generators can be created in a database. Sequences are used via functions called C and C .