![]() ![]() Client is used to connect to the database server.īelow figure shows that client architecture in PostgreSQL.Given below shows how the PostgreSQL Client works: The parameter is optional, and you can use it with the psql utility in PostgreSQL. Port no: We define the use of a port number when connecting to the database server.The psql utility in PostgreSQL uses an optional parameter. If we connect to the local host there is no need to define the host name with psql utility. Host name: If we want to connect from another host, then we need to use this parameter in PostgreSQL.To connect to the database, we need to provide connect grant on database to the specified user. Database name: This defines the database name to connect to the specified database. ![]() We need to provide a password with psql utility to connect the database server. If the password is incorrect, the database will not authenticate the user. Password: We define the password parameter as a means to authenticate the client user with a password.Username: The username is an important parameter used to connect to the database server and authenticate.Psql is a useful and important client utility that connects to the database server. We can use this utility with the username, password, and hostname. Psql: A client utility is used to connect to the database server.Or # psql –U username –W user_password –d database_name –p port_noīelow are the parameter description syntax of the PostgreSQL client: Or # psql –U username –W user_password –d database_name –h hostname # psql –U username –W user_password –d database_name ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |