JIYIK CN >

This tutorial discusses how to convert an integer to a string in PostgreSQL. Convert integer to string in PostgreSQL Consider a quiz_score table that records the score of each participant in a quiz game. The scores are stored in this table...

This article discusses how to escape single quotes in PostgreSQL queries. Escaping single quotes in PostgreSQL Consider a comment table that records user comments. The table has 5 fields: id , userid , postid , comments , commentdate , as s...

JSONB is a decomposed binary format for storing JSON data. If you follow Google Trends or do some research, you'll see that JSON is becoming increasingly popular in the development world. Nowadays, NoSQL can store JSON data by default. It i...

This article will discuss how to find the disk size of a PostgreSQL table and its indexes. Find the disk size of PostgreSQL tables and databases using PSQL You can use \l+ to view the database size and use to \d+ show table size. But before...

When developing an application, developers must understand the different ways they can use to interact with the database. This knowledge will help improve development efficiency because they will know the best way to solve a specific proble...

When we try to connect to the database, Postgres uses SSL to verify the security of the connection. It is disabled by default in HTTP, but in HTTPS, we need the SSL mode of the connection to perform any operation in the Postgres database. I...

This short article shows how to restart PostgreSQL in Ubuntu. Restart PostgreSQL Server in Ubuntu You can restart Postgres server in Ubuntu using the following command. Order: sudo service postgres restart Sometimes the above command does n...

When we develop applications, we end up hosting them with the desired cloud providers under specific monthly or annual subscriptions. Depending on your plan, these subscriptions provide us with different services like data stored in databas...

Unlike SQL Server, PostgreSQL does not have a built-in DATEDIFF function to calculate the difference between dates. However, you can use expressions that include other functions provided by PostgreSQL to obtain the difference between dates....

In this tutorial, we will learn how to insert data from a database hosted on a remote server into a database in our local computer. We will use the remote service provider Heroku PostgreSQL, which offers a free plan for testing purposes. In...

PostgreSQL provides many functions and operators for built-in data types. This tutorial will give an example of extracting the date from a timestamp in PostgreSQL or Postgres. CAST Extracting the date from a timestamp using the operator in...

In this article, we will learn how DATEFIELD to find the day of the week from a given in the table in PostgreSQL. We will also learn about different operations that you can use to manipulate and work with DATEFIELD the data in . We use EXTR...

The remote host uses the Linux system. The first step is definitely to establish a code synchronization mechanism on the local and remote hosts - sftp is the first choice. The second step is to write the CMakeLists.txt file of redis4. There...

clion mainly uses cmake + make for compilation. So for redis4, the main thing is to write the CMakeLists.txt file first. CmakeLists.txt file redis4/CMakeLists.txt cmake_minimum_required (VERSION 3.15 ) project (redis4) set (CMAKE_BUILD_TYPE...

In this article, we will introduce how to install redis under CentOS. In fact, the installation steps are very simple, but there may be some problems in the middle, which is worthy of our attention. Let's take a look at how to install it. F...