- Trending Categories
- Data Structure
- Operating System
- MS Excel
- C Programming
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Query a DB in pgAdmin in PostgreSQL?
Querying a DB in pgAdmin is quite straightforward. Locate your DB in the Servers dropdown on the left, and extend its dropdown, till you see the Schemas dropdown.
Once you click on Schemas, the black button on the top, with the DB symbol and the play arrow will become clickable.
Click on that button, and you will see a Query Tab open up. That’s it, you can type your queries for this particular DB in that box, and click the play arrow button to execute the queries.
The output will be seen on the bottom, in the ‘Data Output’ section.
- Related Articles
- How to Kill queries in pgAdmin in PostgreSQL?
- How to define and query json columns in PostgreSQL?
- How to update a query on Laravel Fluent using db::raw?
- How to combine different columns of a table to yield a single column in query output in PostgreSQL?
- Running a SQL query from specific month in SAP DB
- How to create a table in PostgreSQL?
- How to insert a Python tuple in a PostgreSql database?
- How to change the type of a column in PostgreSQL?
- How to identify foreign key in MySQL DB?
- Aliasing in PostgreSQL?
- How to Change DB Schema to DBO in SQL?
- How to add column to an existing table in PostgreSQL?
- How to merge array of documents in Mongo DB?
- How to look for partial string matches in queries in PostgreSQL?
- How to connect to PostgreSQL database using a JDBC program?