Tux Machines

PostgreSQL Releases, Events, and Technical Articles

Posted by Roy Schestowitz on Jun 26, 2023,

updated Jun 26, 2023

today's howtos

Gentoo Work, and Weekly Reports

PL/Haskell v3.0 Released

↺ PL/Haskell v3.0 Released

> We are pleased to announce the release of version 3.0 of the PL/Haskell extension. This extension allows users to write PostgreSQL functions in the Haskell functional programming language. Instructions can be found here.

↺ PL/Haskell extension

↺ here

> Version 3.0 adds the ability to execute untrusted code which allows for greater flexibility of functionality.

↺ PL/Haskell extension

↺ here

Registration for PGCloud Conference London is Open!

↺ Registration for PGCloud Conference London is Open!

> We are pleased to announce registrations are now open for PGCloud Conference London! The 1-day conference is completely free of charge and you can register to attend via the event website:

> https://pgcloudconferencelondon.splashthat.com/

> Join us in London on 10th August for a day of learning how to optimise, manage and scale PostgreSQL in a cloud environment.

Postgres Random Number

↺ Postgres Random Number

> Random numbers are crucial in various aspects of database management and analysis. For example, in databases, random numbers are fundamental to generate the test data, select random records, distribute the workloads, and enhance the data security. This tutorial explores the different techniques to generate random numbers in PostgreSQL, ranging from basic functions to more advanced […]

Postgres Case-Insensitive

↺ Postgres Case-Insensitive

> Practical tutorial on how to implement the case-insensitive searches in the PostgreSQL databases using the citext data type and by changing the collation.

PostgreSQL Work_Mem

↺ PostgreSQL Work_Mem

> Comprehensive tutorial on understanding the role of the work_mem parameter in PostgreSQL, its effects on the database engine and operations, and more.

Postgres With

↺ Postgres With

> Comprehensive tutorial on how how to create and work with the Common Table Expressions in PostgreSQL using the PostgreSQL WITH keyword using various techniques.

Postgres Variables

↺ Postgres Variables

> Practical tutorial on how to work with PostgreSQL variables and how to to define, reference, and use these variables in a PL/SQL block using various examples.

Postgres Switch User

↺ Postgres Switch User

> Tutorial on switching users in PostgreSQL using the command-line and graphical user interface methods to manage the databases and perform administrative tasks.

PostgreSQL Switch Database

↺ PostgreSQL Switch Database

> Compehensive tutorial on the fundamental methods to switch the databases in the PostgreSQL server using the PSQL utility, SET command, and connection clients.

PostgreSQL Show Extensions

↺ PostgreSQL Show Extensions

> Tutorial on the role of extensions in PostgreSQL and how to install and view the installed extensions in PostgreSQL server using various commands and methods.

Postgres Row_Number Function

↺ Postgres Row_Number Function

> Practical tutorial on the fundamentals of working with the row_number() function in PostgreSQL to assign a unique integer value to each row in the result set.

Postgres Reset Password

↺ Postgres Reset Password

> Guide on the various methods and techniques that we can use to reset a user password in PostgreSQL server using the PSQL utility, pgAdmin, and editing password.

Remove the NOT NULL Constraint in Postgres

↺ Remove the NOT NULL Constraint in Postgres

> Practical guide on on how we can work with the NOT NOLL constraint in PostgreSQL and how to drop or remove an existing NOT NULL constraint from a given column.

PostgreSQL “Relation Doe Not Exist” Error

↺ PostgreSQL “Relation Doe Not Exist” Error

> Simple guide on what the "Postgres relation does not exist" error means, the possible causes, and the potential solutions or techniques to resolve this error.

Postgres Rank

↺ Postgres Rank

> How to work with rank() function in PostgreSQL to fetch the rank of a given row from a result set based on the defined conditions and create complex queries.

gemini.tuxmachines.org