AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Pgadmin 4 postgres.app connection12/15/2023 ![]() ![]() This way, you can issue any statement of your choice.Ĭonnecting to a Postgres Database Server Using pgAdminĪnother way to connect to a PostgreSQL database server is by using pgAdmin. For instance, run the below-given command to see the Postgres version: SELECT VERSION() Similarly, you can execute any statement of your choice depending on the situation. The below statement will show you the list of available databases: Upon connecting to the Postgres Database Server, you can execute any statement/command. Step #3: Interact With the Database Server Finally, specify the password that you set during the PostgreSQL installation: Press enter if you did not change the default values during installation as a result, SQL SHELL will pick the default values for each field. Now, provide all the required information, such as server address, database name, port number (default port number is 5432), user name, and password. For this purpose, type psql in the Windows search bar and click on the respective app to open it:Ĭlicking on the targeted app will open the following window: Here are the stepwise instructions that will assist you in establishing a connection with the Postgres database server via psql:įirstly, you need to open the psql to avail any of its functionality. SQL SHELL, or psql for short, is an open-source, terminal-based, cost-effective, secure, and scalable tool that allows us to execute queries/commands interactively. So, what are you waiting for? Let’s start!Ĭonnecting to a Postgres Database Server Using psql Connecting to a Postgres Database Server Using pgAdmin.Connecting to a Postgres Database Server Using psql.This post will cover the following topics: This write-up will assist the beginners who have installed PostgreSQL on their PCs and are now looking to establish a connection to it. Both these tools assist us in working with Postgres. pgAdmin is a web-based GUI tool, while psql is a terminal-based tool. Installing the PostgreSQL on your machine will also install a couple of very handy tools, such as pgAdmin, and SQL SHELL.
0 Comments
Read More
Leave a Reply. |