Bilal Shahid

howto · 2025-03-14

How to Kill a Process ID in PostgreSQL

This article explains how to kill or stop a running query in the background in PostgreSQL. Learn effective methods using Python libraries like psycopg2, SQLAlchemy, and asyncpg to manage your database processes efficiently. Discover the importance of process IDs and how to maintain optimal database performance with practical examples and clear explanations.

howto · 2025-03-11

How to Add a Unique Constraint After Creating a Table in PostgreSQL

This article explains how to add a unique constraint after already having created a table in PostgreSQL. Learn step-by-step methods to ensure data integrity and prevent duplicates in your database. Discover best practices, SQL commands, and troubleshooting techniques to enhance your database management skills effectively.

howto · 2024-02-15

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.

howto · 2024-02-15

How to Remotely Connect to Another Instance Using PSQL

This article explains how to remotely connect to another PostgreSQL instance using the Psql console.

howto · 2024-02-15

Interface vs Abstract Classes in C#

This article teaches us the difference between interface and abstract classes.

howto · 2024-02-15

How to Order by Clause in PostgreSQL

This article describes the order by clause in PostresSQL and demonstrates its use.

howto · 2024-02-15

How to Limit Rows in PostgreSQL

This article shows the use of the LIMIT and FETCH FIRST clause in PostgreSQL.

howto · 2024-02-15

Varchar vs Text in PostgreSQL

This article shows the difference between varchar and text datatypes in PostgreSQL and demonstrates each individually using code examples.

howto · 2024-02-15

How to Unnest in PostgreSQL

This article describes the PostgreSQL unnest and demonstrates its usage.

howto · 2024-02-15

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.

howto · 2024-02-15

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.

howto · 2024-02-15

How to Create an Array From a Specific Range in Excel Using VBA

This article illustrates how to create an array using a specific range in Microsoft Excel using VBA.

howto · 2024-02-15

Project Password in Microsoft Excel VBA

This article explains the usage of a project password in Microsoft Excel VBA.

howto · 2024-02-15

On Error Statement in Microsoft Excel VBA

This article explains the usage of the On Error statement in Microsoft Excel VBA.

howto · 2024-02-15

MsgBox in Microsoft Excel VBA

This article explains the usage of MsgBox in Microsoft Excel VBA.

howto · 2024-02-15

How to Check if a Cell Is Empty in Microsoft Excel VBA

This article explains the ways to check if a cell is empty in Microsoft Excel VBA.

howto · 2024-02-15

How to Unsort Sorted Data in Microsoft Excel VBA

This article explains the ways to unsort sorted data in Microsoft Excel VBA.

howto · 2024-02-15

How to Convert Text to Number in Microsoft Excel VBA

This article explains the ways to convert textual data to numbers in Microsoft Excel VBA.

howto · 2024-02-12

How to SELECT if String Contains a Substring Match in PostgreSQL

This article explains how to select if a string contains a specific value in PostgreSQL.

howto · 2024-02-12

How to Convert a Dictionary to JSON String in C#

This article teaches how to convert a Dictionary to a JSON string in C#.

howto · 2024-02-02

How to Convert String to Double in C#

This tutorial demonstrates how to convert a string in C# to a double type.

howto · 2024-02-02

How to Create Table if It Does Not Exist in PostgreSQL

This article discusses how to create a table in PostgreSQL if it does not exist.

howto · 2024-02-02

How to Upsert (Merge, Insert on Duplicate Update) in PostgreSQL

This article describes how to perform an upsert operation in PostgreSQL.

howto · 2024-02-02

How to Upsert (Insert on Duplicate Update, Merge) in PostgreSQL With EXCLUDE Values

This article shows ways to use the EXCLUDED table values in upsert in PostgreSQL.

howto · 2024-02-02

How to Concatenate Columns in PostgreSQL Using Select

This article describes how to concatenate columns in PostgreSQL using Select method.

howto · 2024-02-02

How to Extract Day of Week From Date Field in PostgreSQL

This article explains how to extract the respective day of the week from the date field in PostgreSQL.

howto · 2024-02-02

How to List All Tables in PostgreSQL INFORMATION_SCHEMA Table

This article shows the different ways to list all the tables in PostgreSQL INFORMATION_SCHEMA.

howto · 2024-02-02

How to Insert on Duplicate Update in PostgreSQL

This article explains how to perform an Insert on Duplicate Update in PostgreSQL.

howto · 2024-02-02

How to Use NOT IN With Subquery in PostgreSQL

This article describes how to use NOT IN in PostgreSQL.

howto · 2024-02-02

How to Subtract a Day From a Timestamp Date in PostgreSQL

This article describes how to subtract a day from a timestamp date in PostgreSQL.

howto · 2024-02-02

How to Drop Database Through PSQL in PostgreSQL

This article describes how to drop a database through Psql in PostgreSQL.

howto · 2024-02-02

How to Compare Dates in Datetime Fields in PostgreSQL

This article describes how to compare two DATETIME fields in PostgreSQL.

howto · 2024-02-02

How to Round an Average to 2 Decimal Places in PostgreSQL

This article describes how to round an average in PostgreSQL to 2 decimal places.

howto · 2024-02-02

How to Exit From the Command Line Utility in PostgreSQL

This article describes how to exit from the Psql command line utility in PostgreSQL.

howto · 2024-02-02

How to Terminate a PostgreSQL Connection

This article describes how to terminate an opened connection in PostgreSQL.

howto · 2024-02-02

How to Save PL/pgSQL Output From PostgreSQL to CSV

This article describes how to save the PL/pgSQL output from PostgreSQL to a CSV file.

howto · 2024-02-02

How to Run PostgreSQL Queries in PSQL

This article describes how to run Queries from the PostgreSQL Command Line Tool.

howto · 2024-02-02

How to Rename a Table Inside a Schema in PostgreSQL

This article describes renaming a table inside a schema in PostgreSQL.

howto · 2024-02-02

How to Create a Pivot Table in PostgreSQL

This article describes how to create a pivot table in PostgreSQL.

howto · 2024-02-02

How to Select Random Rows in PostgreSQL

This article teaches about the different ways we can select random rows in PostgreSQL.

howto · 2024-02-02

How to Comment Characters in PostgreSQL

This article explains us about the process of commenting characters in PostgreSQL.

howto · 2024-02-02

How to Create Role or User if It Does Not Exist in PostgreSQL

This article teaches how to create a PostgreSQL role for the first time.

howto · 2024-02-02

How to Configure PostgreSQL in Linux

This article teaches how to configure and use PostgreSQL for the first time in Linux.

howto · 2024-02-02

How to Write Case-Insensitive Queries in PostgreSQL

This article teaches how to write case-insensitive queries in PostgreSQL .

howto · 2024-02-02

How to Start PostgreSQL Server on Windows

This article teaches how to start a PostgreSQL server on Windows.

howto · 2024-02-02

How to Use UTC Current Time as Default in PostgreSQL

This article teaches how to use UTC current time as default in PostgreSQL.

howto · 2024-02-02

How to Implement a Property in an Interface in C#

This article teaches how to implement a property in an interface in C#.

howto · 2024-02-02

How to Swap Variable Values Without the Use of Temporary Variable in C#

This article teaches how to swap variable values without the use of temporary variables.

howto · 2024-02-02

How to Toggle a Boolean Variable in C#

This article teaches us the ways in which we can toggle boolean variables in C#.

howto · 2024-02-02

How to Implement a Read-Only Property in C#

This article teaches us how to implement read-only properties in C#.

howto · 2024-02-02

How to Check for the Existence of a Dictionary Key in C#

This article teaches us how to check or detect if a dictionary key exists in C#.

howto · 2024-02-02

How to Post JSON to a Server in C#

This article tells us how to post JSON to a server in C#.

howto · 2024-02-02

How to Draw Circles in C#

This article teaches us how to draw circles with System.Drawing in C#.

howto · 2024-02-02

How to Obtain a Distinct List Based on One or More Properties in C#

This article will discuss the basics of using the Distinct() function in LINQ and obtaining a distinct list based on one or more properties in C#.

howto · 2024-02-02

How to Get Array Length in PostgreSQL

This article discusses calculating the length of an array in PostgreSQL.

howto · 2024-02-02

How to Find and Delete Duplicate Records in a Database in PostgreSQL

This article shows how to find duplicate records in a database and then delete them in PostgreSQL.

howto · 2024-02-02

How to Delete All Table Rows in PostgreSQL

This article shows the method to delete all rows in a table in PostgreSQL.

howto · 2024-02-02

How to Check if PostgreSQL Is Installed on Linux

This tutorial explains how to check whether we have installed PostgreSQL on Linux or not.

howto · 2024-02-02

How to Upgrade the PostgreSQL Server Version Without Losing Any Data

This tutorial describes the procedure to update the PostgreSQL server version without losing any data.

howto · 2024-02-02

How to Install PSQL Without Installing Full PostgreSQL

The article demonstrates a procedure to install psql without installing the full PostgreSQL server using Homebrew services.

howto · 2024-02-02

How to Grant Privileges to the User in PostgreSQL

This article explains how to grant privileges to the user in PostgreSQL.

howto · 2024-02-02

How to Transpose Columns to Rows in PostgreSQL

This article describes the method to transpose columns to rows in PostgreSQL.

howto · 2024-02-02

How to Select From Dual in PostgreSQL

This article discusses the dual table and the alternatives of selecting from dual in PostgreSQL.

howto · 2024-02-02

How to Run PostgreSQL in Memory Only

This article discusses using a database in memory in PostgreSQL.

howto · 2024-02-02

How to Insert Current Timestamp in PostgreSQL

This article shows the different ways to insert current timestamp in PostgreSQL.

howto · 2024-02-02

How to Convert From Unix Epoch to the Date in PostgreSQL

This article mentions how to convert Unix epoch to the date in PostgreSQL.

howto · 2024-02-02

How to Add PostgreSQL Database as a Maven Dependency

This article provides an in-depth approach on how to add the PostgreSQL database dependency to Maven.

howto · 2024-02-02

How to PostgreSQL Database Encryption

This article explains multiple ways to encrypt your data in PostgreSQL.

howto · 2024-02-02

How to PostgreSQL - Check Date and Time Relative to Today

This article demonstrates how to check the current date and time relative to today.

howto · 2024-02-02

How to Log All PostgreSQL Queries

This article demonstrates how to log all PostgreSQL queries. It also shows how to alter configuration files.

howto · 2024-02-02

How to Install and Troubleshoot the ODBC Driver for PostgreSQL

This article discusses how a user can install and set up a Postgres ODBC driver along with common problems users may face.

howto · 2024-02-02

How to Drop Not Null Constraint in PostgreSQL

This article discusses how to drop not null constraint in different ways.

howto · 2024-02-02

How to Create a Read Only User in PostgreSQL

This tutorial demonstrates creating a read-only user in PostgreSQL.

howto · 2024-02-02

How to Open a Workbook by Specifying Its Path in Microsoft Excel Using VBA

This article demonstrates how to use a command in VBA to open another workbook just by specifying its path.

howto · 2024-02-02

How to Copy and Paste Values in VBA

This article demonstrates how to copy the values of one column to another in the same sheet or a different sheet in Excel using VBA.

howto · 2024-02-02

How to Convert a Column Number to Letter in Excel Using VBA

This article describes different functions that convert a column number to a column letter in Microsoft Excel using VBA.

howto · 2024-02-02

How to Reference Another Sheet in VLookup Using VBA

This article explains how to reference another sheet in VLookup using VBA.

howto · 2024-02-02

How to Read a Text File Line by Line in VBA

This article describes how to parse through the entire file, line by line, in VBA.

howto · 2024-02-02

How to Parse JSON With VBA

This article describes how to parse JSON without using external libraries in VBA.

howto · 2024-02-02

How to Clear the Immediate Window Using VBA

This article describes how to clear the contents of the immediate window in Microsoft applications using VBA.

howto · 2024-02-02

How to Use Regular Expressions in Excel VBA

This article describes how to create and match strings based on a regular expression in Microsoft Excel using VBA.

howto · 2024-02-02

How to Save as in Microsoft Excel VBA

This article explains the usage of the Save As function in Microsoft Excel VBA.

howto · 2024-02-02

How to Prevent Duplication in SQLite

This article discusses the multiple ways you can prevent duplicated records in your database.

howto · 2024-02-02

How to Loop Through Files in a Folder Using VBA

This article describes how to loop through the files that are stored in a folder using VBA.

howto · 2024-02-02

How to Import CSV Into Access using VBA

This article describes the method to import CSV into Access VBA.

howto · 2024-02-02

How to Create and Use Temporary Tables in SQLite

This article discusses the creation and use of temporary tables in depth in SQLite.

howto · 2024-02-02

How to Create a Progress Bar in Excel VBA

This article describes how to create a progress bar in Microsoft Excel using VBA.

howto · 2024-02-02

How to Convert Integer to String Data Type in Microsoft Excel VBA

This article explains the ways to convert an integer data type to string in Microsoft Excel VBA.

howto · 2024-02-02

How to Use SQLite Electron Module

This article explains how to use SQLite Electron.

howto · 2024-02-02

How to Use JSON Data in SQLite

This article explains how to use JSON data in SQLite.

howto · 2024-02-02

How to Use for Each on an Array Using VBA

This article mentions how to use a For Each loop on an array that contains several elements in VBA.

howto · 2024-02-02

How to Parse XML in Microsoft Excel VBA

This article explains how to parse XML in Microsoft Excel VBA.

howto · 2024-02-02

How to Open a Database File From SQLite

This article explains how to use the open command of SQLite.

howto · 2024-02-02

How to INSERT a New Record or UPDATE One if It Already Exists in SQLite

This article explains how to use the INSERT, UPDATE, and INSERT OR UPDATE commands. This also discusses how to insert a new record or update a record if it already exists.

howto · 2024-02-02

How to Declare and Use Variables in SQLite

This article discusses the declaration and usage of variables in SQLite.

howto · 2024-02-02

How to Shutdown/Stop MongoDB

This article explains the various methods to shut down MongoDB.

howto · 2024-02-02

How to Import CSV Files in MongoDB

This article describes how to import the comma-separated values (CSV) file using the mongoimport command.

howto · 2024-02-02

How to Convert a String to Date in MongoDB

This article explains methods to convert a string to a date field in various versions of MongoDB.

howto · 2024-02-02

How to Build a MongoDB REST API

This article instructs users how to build a MongoDB REST API.

howto · 2024-02-02

How to Use an ORM in MongoDB

This article explains the usage of ORM in MongoDB.

howto · 2024-02-02

How to Check if MongoDB Is Installed on Windows

This article describes four different methods that help you to check if the MongoDB software is installed on your Windows or not.

howto · 2024-02-02

How to Connect MongoDB With PowerShell

This article explains how you can use MongoDB with PowerShell.

howto · 2023-11-30

Method Group in C#

This article teaches us about method groups in C#.

howto · 2023-10-12

Callback in C#

This article provides a brief explanation to what a callback is in C#.

howto · 2023-10-12

URL Encoding in C#

This article teaches how to encode a URL in C#.

howto · 2023-01-30

Auto Increment Values in PostgreSQL

This article describes how to auto increment values in PostgreSQL.

howto · 2023-01-30

Alternatives to DATEADD() in PostgreSQL

This article discusses alternatives to DATEADD() in PostgreSQL.

howto · 2022-12-16

Locking in MongoDB

This article explains the concept of locking in MongoDB.

howto · 2022-12-16

Difference Between ObjectId and $Oid in MongoDB

This article describes the difference between the ObjectId and $oid in MongoDB. Examples have been provided within the article to clarify the difference between the two entities.

howto · 2022-11-08

SQLite Describe a Table

This article explains SQLite describe tables, syntax as well as its functionality.

howto · 2022-11-08

SQLite Data Types

This article discusses the various data types in SQLite.

howto · 2022-10-25

Regex Operator in SQLite

This article explains everything you need to know to use the regex operator correctly.

howto · 2022-10-25

Encryption and Password Protection in SQLite

This article discusses the methods with which your databases can be password protected and encrypted.

howto · 2022-09-23

PostgreSQL Default Port

This article clears all confusions that users may have while figuring out the right PostgreSQL default port and helps navigate them through errors that may show up.

howto · 2022-09-23

Introduction to Comparison Operators in VBA

This article describes the various comparison operators offered by VBA and discusses the <> operator in detail.

howto · 2022-09-22

Introduction to Views in PostgreSQL

This article introduces how we can create, edit, display, and delete views in PostgreSQL.

howto · 2022-09-22

Best Postgres Clients Available for Windows Users

This article explains what Postgres clients are and describes some options that Windows users may adopt.

howto · 2022-09-11

PostgreSQL Port 5432

This article explains the workings of PostgreSQL port 5432 and issues that may occur while trying to connect to it.

howto · 2022-09-07

The initdb Command in PostgreSQL

This article depicts the working of the initdb command in the PostgreSQL server.

howto · 2022-09-07

The DISTINCT Clause in PostgreSQL

This article demonstrates the use of the distinct clause in PostgreSQL.

howto · 2022-08-31

Database Cluster in PostgreSQL

This article explains what a database cluster is and how to create one in PostgreSQL.

howto · 2022-04-30

NEXTVAL Function in PostgreSQL

This article teaches about the functionality of the NEXTVAL() function in PostgreSQL.

howto · 2022-04-05

Differences Between the IN and ANY Operators in PostgreSQL

This article talks about the differences between the IN and the ANY operators in PostgreSQL.

howto · 2022-04-04

Foreign Key ON DELETE CASCADE in PostgreSQL

This article explains how to perform ON DELETE/CASCADE in PostgreSQL.

howto · 2022-04-03

Default Username/Password for PostgreSQL Server in Rails 4

This article explains the default settings for the user in PostgreSQL Server in Rails 4.

howto · 2022-03-25

Foreign Key Syntax in PostgreSQL

This article describes how to correctly make a foreign key relationship in PostgreSQL.