This chapter mainly discusses the management of schemas and users in PostgreSQL and explains the key differences between a schema and a user and how to create and manage them using authentication and privilege management with support of roles and privileges. Also, this chapter illustrates different ways on how a user can connect to the PostgreSQL database both from within a database server and from a remote host. After reading this chapter, you will understand the authentication methods defined in PostgreSQL and options to use when connecting to PostgreSQL databases.

错误:搜索内容不能为空,请输入英文关键词
错误:关键词超出字数限制,请精简
高级检索

PostgreSQL Management of Database Server

  • Y V Ravi Kumar,
  • Arun Kumar Samayam,
  • Phani Kadambari

摘要

This chapter mainly discusses the management of schemas and users in PostgreSQL and explains the key differences between a schema and a user and how to create and manage them using authentication and privilege management with support of roles and privileges. Also, this chapter illustrates different ways on how a user can connect to the PostgreSQL database both from within a database server and from a remote host. After reading this chapter, you will understand the authentication methods defined in PostgreSQL and options to use when connecting to PostgreSQL databases.