PostgreSQL

How-tos How to Extract Date From Timestamp in PostgreSQL This tutorial explains various ways to extract the date from a timestamp in PostgreSQL. Learn how to use the DATE, TO_CHAR, and EXTRACT functions with practical examples. Enhance … ↗ How-tos How to Restart PostgreSQL in Ubuntu 18.04 Learn how to restart PostgreSQL in Ubuntu 18.04 using various methods including terminal commands, systemctl, and pg_ctl. This comprehensive guide provides clear instructions and … ↗ How-tos How to Change the Owner of the PostgreSQL Database Learn how to change the owner of a PostgreSQL database using the REASSIGN command and other SQL methods. This guide provides clear examples and explanations for transferring … ↗ How-tos PostgreSQL Equivalent of SYSDATE This article discusses the PostgreSQL equivalent of Oracle's SYSDATE. Learn how to use functions like CURRENT_TIMESTAMP, NOW(), LOCALTIMESTAMP, and clock_timestamp() to retrieve … ↗ How-tos PostgreSQL DATEDIFF Function This tutorial discusses how to calculate date difference in PostgreSQL using various methods like direct subtraction, the AGE function, and the EXTRACT function. Learn to … ↗ How-tos How to Drop Primary Key in PostgreSQL This article discusses using the ALTER TABLE query to drop the primary key constraint in PostgreSQL. Learn how to manage your database schema effectively by understanding the … ↗ How-tos How to Get Column Names in PostgreSQL Learn how to get column names in PostgreSQL using two effective methods: the psql command-line interface and SQL queries. This article provides clear explanations and code examples … ↗ How-tos How to Cast an Integer to String in PostgreSQL This tutorial discusses how to cast an integer to a string in PostgreSQL. Learn various methods, including using the CAST function, the :: operator, and the CONCAT function. … ↗ How-tos How to Drop if Exists vs Drop in PostgreSQL Learn the differences between DROP IF EXISTS and DROP in PostgreSQL. This article explores how to safely drop tables, manage foreign key references, and avoid errors. Discover … ↗ How-tos How to Print Variable in PostgreSQL Learn how to print variables in PostgreSQL using the RAISE NOTICE command. This article provides a comprehensive guide on printing simple variables, multiple variables, and … ↗ How-tos How to Use CASE in PostgreSQL This article shows how to use CASE statement and gives examples in PostgreSQL. ↗ How-tos PostgreSQL Is Not a NoSQL Database This article will teach the reader the different types of databases such as NoSQL and which type of database PostgreSQL belongs to. ↗ How-tos How to Single Query to Rename and Change Column Type in PostgreSQL This article describes how to use just a single query to rename a column as well as change its type in PostgreSQL. ↗ How-tos How to Remotely Connect to Another Instance Using PSQL This article explains how to remotely connect to another PostgreSQL instance using the Psql console. ↗ How-tos How to Order by Clause in PostgreSQL This article describes the order by clause in PostresSQL and demonstrates its use. ↗ How-tos How to Limit Rows in PostgreSQL This article shows the use of the LIMIT and FETCH FIRST clause in PostgreSQL. ↗ How-tos Varchar vs Text in PostgreSQL This article shows the difference between varchar and text datatypes in PostgreSQL and demonstrates each individually using code examples. ↗ How-tos How to Unnest in PostgreSQL This article describes the PostgreSQL unnest and demonstrates its usage. ↗ How-tos How to Convert Timezone in PostgreSQL Server This article demonstrates different functions and statements in PostgreSQL that allow you to change from one timezone to another. ↗ How-tos How to Install and Start PostgreSQL Server on Mac This article walks mac users through installing and starting the PostgreSQL server on their system. It also analyses common problems that occur while starting it. ↗ How-tos How to List Tables in PostgreSQL This article shows the altenative ways or commands that can be used to return a collection of tables in a database using PostgreSQL. ↗ How-tos How to Insert Into Select in PostgreSQL This article covers how we can insert data from an entity in a remote database to an entity in a local database using an SQL select statement in PostgreSQL. ↗ How-tos How to Drop All Tables in PostgreSQL This article shows how multiple tables in a database can be deleted without removing the database conatining the tables in PostgreSQL. ↗ How-tos How to Use Database in PostgreSQL This article demonstrates connecting to a database, creating a new database, and creating a table in PostgreSQL. ↗