The command line client program psql has some \d commands to show information about types, operators, functions, aggregates, etc. - use \? to --- 334,343 ---- There are a number of PostgreSQL books available for purchase. One of the most popular ones is by Korry Douglas. A list of book reviews can be found at http://www.postgresql.org/docs/books/. There is also a collection of PostgreSQL technical articles at http://www.postgresql.org/docs/techdocs.
The command line client program psql has some \d commands to show information about types, operators, functions, aggregates, etc. - use \? to *************** *** 349,358 **** SQL?
First, consider the PostgreSQL-specific books mentioned above. ! Another one is "Teach Yourself SQL in 21 Days, Second Edition" ! at http://members.tripod.com/er4ebus/sql/index.htm. ! Many of our users like The Practical SQL Handbook, Bowman, Judith S., et al., Addison-Wesley. Others like The Complete Reference SQL, Groff et al., McGraw-Hill.
--- 349,355 ---- SQL?First, consider the PostgreSQL-specific books mentioned above. ! Many of our users also like The Practical SQL Handbook, Bowman, Judith S., et al., Addison-Wesley. Others like The Complete Reference SQL, Groff et al., McGraw-Hill.
*************** *** 541,547 ****It is easy using set-returning functions, ! http://www.postgresql.org/docs/techdocs.17
. ! !PL/PgSQL caches function scripts, and an unfortunate side effect ! is that if a PL/PgSQL function accesses a temporary table, and that ! table is later dropped and recreated, and the function called again, ! the function will fail because the cached function contents still ! point to the old temporary table. The solution is to use ! EXECUTE for temporary table access in PL/PgSQL. This ! will cause the query to be reparsed every time.
It is easy using set-returning functions, ! http://www.postgresql.org/docs/techdocs.17.
Multi-master replication allows read/write queries to be sent to --- 1051,1057 ---- queries, while slaves can only accept read/SELECT queries. The most popular freely available master-slave PostgreSQL replication solution is Slony-I.
Multi-master replication allows read/write queries to be sent to *************** *** 1085,1091 **** double-quotes around table or column names during table creation. When double-quotes are used, table and column names (called identifiers) are stored case-sensitive, meaning you must use double-quotes when referencing the names in a query. Some interfaces, like pgAdmin, automatically double-quote identifiers during table creation. --- 1070,1076 ---- double-quotes around table or column names during table creation. When double-quotes are used, table and column names (called identifiers) are stored case-sensitive, meaning you must use double-quotes when referencing the names in a query. Some interfaces, like pgAdmin, automatically double-quote identifiers during table creation.