How to List Users in PostgreSQL

Introduction This tutorial will explain how to list users in a PostgreSQL. The PSQL is a useful PostgreSQL utility that enables the user to interactively query databases and assign, change and audit users roles as needed. The PSQL utility supports an assortment of meta commands that enable users to write scripts and automate a wide … Continued

Psql Connect to a Database PostgreSQL 783

Introduction Psql is a helper function available through the pgAdmin tool that is included in your PostgreSQL installation. As an interactive program, psql allows you to connect to the server where the PostgreSQL database is located. Interactivity is psql’s greatest benefit because it enables you to effectively handle database object management as well as administer … Continued

What Is A PostgreSQL Cursor?

Introduction to Cursors in PostgreSQL If you’re writing code that interacts with PostgreSQL using Python or PHP, you’ll probably want to use cursors in your scripts. A PostgreSQL database cursor is a read-only pointer that allows a program, regardless of the language used, to access the result set of a query. This conserves the free … Continued

Keep in the know!

Subscribe to our emails and we’ll let you know what’s going on at ObjectRocket. We hate spam and make it easy to unsubscribe.