krb_server_keyfile (string) Sets the location of the Kerberos server key file. See Section 19.2.3 for details. db_user_namespace (boolean) This allows per-database user names. It is off by default. If this is on used as shared memory. That is the sort of configuration commonly used for other databases such as DB/2. It may, however, be necessary to modify the global ulimit information in /etc/security/limits, pg_tablespace system catalog, for example SELECT spcname FROM pg_tablespace; The psql program’s \db meta-command is also useful for listing the existing tablespaces. 295 Chapter 18. Managing Databases

krb_server_keyfile (string) Sets the location of the Kerberos server key file. See Section 19.2.3 for details. db_user_namespace (boolean) This allows per-database user names. It is off by default. If this is on used as shared memory. That is the sort of configuration commonly used for other databases such as DB/2. It may, however, be necessary to modify the global ulimit information in /etc/security/limits, pg_tablespace system catalog, for exam- ple SELECT spcname FROM pg_tablespace; The psql program’s \db meta-command is also useful for listing the existing tablespaces. PostgreSQL makes extensive use of

pg_database .............................................................................. 2261 53.16. pg_db_role_setting ................................................................ 2262 53.17. pg_default_acl Columns ................................................................................. 2261 53.16. pg_db_role_setting Columns ................................................................... 2262 53.17 \dp TABLE (and table-like objects) arwdDxt none \dp Table column arwx none \dp TABLESPACE C none \db+ TYPE U U \dT+ The privileges that have been granted for a particular object are displayed as a

................................................................................... 2384 53.16. pg_db_role_setting ..................................................................... 2385 53.17. pg_default_acl ................................................................................... 2384 53.16. pg_db_role_setting Columns ........................................................................ 2385 \dp TABLE (and table-like objects) arwdDxt none \dp Table column arwx none \dp TABLESPACE C none \db+ TYPE U U \dT+ The privileges that have been granted for a particular object are displayed as a

................................................................................... 2453 51.16. pg_db_role_setting ..................................................................... 2454 51.17. pg_default_acl ................................................................................... 2453 51.16. pg_db_role_setting Columns ........................................................................ 2455 \dp TABLE (and table-like objects) arwdDxtm none \dp Table column arwx none \dp TABLESPACE C none \db+ TYPE U U \dT+ The privileges that have been granted for a particular object are displayed as a

pg_database .............................................................................. 2318 51.16. pg_db_role_setting ................................................................ 2319 51.17. pg_default_acl Columns ................................................................................. 2318 51.16. pg_db_role_setting Columns ................................................................... 2319 51.17 \dp TABLE (and table-like objects) arwdDxtm none \dp Table column arwx none \dp TABLESPACE C none \db+ TYPE U U \dT+ The privileges that have been granted for a particular object are displayed as a

.............................................................................1925 xxxi 48.16. pg_db_role_setting ..................................................................................... PostgreSQL can be extended by the user in many ways, for example by adding new • data types 1. http://db.cs.berkeley.edu/postgres.html xlv Preface • functions • operators • aggregate functions • index canonicalized to make equivalent URLs match: • http://www.pgsql.ru/db/mw/index.html • http://www.pgsql.ru/db/mw/ • http://www.pgsql.ru/db/../db/mw/index.html • Color names can be replaced by their hexadecimal

....................................................................................1810 48.16. pg_db_role_setting ...................................................................................1812 adding new • data types • functions • operators • aggregate functions • index methods 1. http://db.cs.berkeley.edu/postgres.html xlii Preface • procedural languages And because of the liberal license canonicalized to make equivalent URLs match: • http://www.pgsql.ru/db/mw/index.html • http://www.pgsql.ru/db/mw/ • http://www.pgsql.ru/db/../db/mw/index.html • Color names can be replaced by their hexadecimal

used as shared memory. That is the sort of configuration commonly used for other databases such as DB/2. It may, however, be necessary to modify the global ulimit information in /etc/security/limits, case-insensitively. The default is off (case sensitive). This parameter can only be set at server start. db_user_namespace (boolean) This enables per-database user names. It is off by default. If this is on example 324 Chapter 19. Managing Databases SELECT spcname FROM pg_tablespace; The psql program’s \db meta-command is also useful for listing the existing tablespaces. PostgreSQL makes extensive use of

....................................................................................1910 49.16. pg_db_role_setting ...................................................................................1913 canonicalized to make equivalent URLs match: • http://www.pgsql.ru/db/mw/index.html • http://www.pgsql.ru/db/mw/ • http://www.pgsql.ru/db/../db/mw/index.html • Color names can be replaced by their hexadecimal used as shared memory. That is the sort of configuration commonly used for other databases such as DB/2. It might, however, be necessary to modify the global ulimit information in /etc/security/limits