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
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
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
