Sling Academy
Home/PostgreSQL/Page 30

PostgreSQL

PostgreSQL is a free and open-source database system that supports both relational and non-relational queries. It is reliable, user-friendly, and extensible, with many features such as user-defined types, table inheritance, nested transactions, and asynchronous replication. It supports various programming languages and platforms.

Mastering LPAD and RPAD String Functions in PostgreSQL

Updated: Jan 05, 2024
Introduction Working with strings is an essential part of database manipulation, as it is often necessary to manipulate text data to fit certain formats or align with data standards. PostgreSQL, as a robust and feature-rich database......

PostgreSQL: TRIM, BTRIM, LTRIM, and RTRIM Functions

Updated: Jan 05, 2024
Overview PostgreSQL provides several functions to manipulate text strings, allowing you to tidy up data and make sure it conforms to a certain format. Among these string functions are the TRIM family of functions which includes TRIM,......

Using SPLIT_PART String Function in PostgreSQL

Updated: Jan 05, 2024
Introduction to SPLIT_PART The SPLIT_PART function is a powerful tool in PostgreSQL that allows users to split a string into parts based on a specified delimiter and then return the nth part of the split string. This functionality is......

Using LEFT and RIGHT String Functions in PostgreSQL

Updated: Jan 05, 2024
Introduction The LEFT and RIGHT functions in PostgreSQL are part of a suite of string functions that programmers can use to manipulate strings in PostgreSQL databases. They allow developers to extract substrings from a field by......

PostgreSQL String Functions: UPPER, LOWER, and INITCAP

Updated: Jan 05, 2024
Introduction PostgreSQL, the advanced open-source database, provides several in-built string functions to handle and manipulate text data efficiently. Among these are the UPPER, LOWER, and INITCAP functions, which are used for case......

PostgreSQL: How to create an alphanumeric sequence

Updated: Jan 05, 2024
Introduction Creating sequences in PostgreSQL usually involves numeric values, but sometimes applications require unique alphanumeric identifiers. This tutorial demonstrates methods to generate such sequences. Understanding......

PostgreSQL: How to share a sequence between tables

Updated: Jan 05, 2024
Introduction In PostgreSQL, sequences are special objects used to generate unique numbers, often for primary key values. This tutorial will guide you on how to create and share a sequence across multiple PostgreSQL tables, ensuring......

PostgreSQL: How to list all sequences of a database

Updated: Jan 05, 2024
Overview Sequences in PostgreSQL are often used to generate unique identifiers for rows in a table. Understanding how to manage and list them is key for database administration. This tutorial walks you through several methods to list......

PostgreSQL: How to attach a sequence to a table column

Updated: Jan 05, 2024
Introduction Attaching a sequence to a table column in PostgreSQL is an essential skill for effectively auto-incrementing values, such as an ID. In this extensive guide, we’ll look at multiple methods with code examples to help......

PostgreSQL: How to Delete a Sequence

Updated: Jan 05, 2024
Introduction Managing sequences in PostgreSQL is critical for ensuring data integrity and performance. This guide provides detailed instructions for deleting sequences from your PostgreSQL database, utilizing a variety of techniques......

PostgreSQL: Descending sequence and CYCLE sequence

Updated: Jan 05, 2024
Introduction In PostgreSQL, sequences are special schemas that generate ordered integers. They are often used to create unique identifiers for records. We’ll explore how to create a sequence that descends and how to make a......

PostgreSQL: Creating a sequence using a specific data type

Updated: Jan 05, 2024
Introduction Sequences are essential database objects in PostgreSQL used to generate a series of unique numbers, often serving as surrogate primary keys. This tutorial walks you through creating sequences with explicit data types to......