Practical solutions

PostgreSQL Howtos How-To Guides

Solve the problem. Keep building. Collection of PostgreSQL how-to articles

Find the answer you need

Browse practical solutions, grouped by the task you're working on.

__COUNT__ entries on this page

PostgreSQL DatabaseHow to Drop Database Through PSQL in PostgreSQLThis article describes how to drop a database through Psql in PostgreSQL. PostgreSQL DatetimeHow to Compare Dates in Datetime Fields in PostgreSQLThis article describes how to compare two DATETIME fields in PostgreSQL. PostgreSQL VariableHow to Use Variables in PostgreSQLYou might need to use variables in PostgreSQL. You can declare your variables using DECLARE in the PL/SQL. PostgreSQL LoopHow to Use Loop in PostgreSQLIn PL/SQL, you might need to use the loop in Postgres. We can use the FOR and WHILE statements to create a loop. PostgreSQL ConnectionHow to Show Connections in PostgreSQLThis article shows how to list active connections on PostgreSQL. PostgreSQL FileHow to Run SQL File in PSQLThis article explains how to run a SQL file direct from terminal/command-line or psql shell. For that, you need to specify the hostname, port, username, and database name. PostgreSQL ConfigurationHow to Locate Configuration Files in PostgreSQL on UbuntuThis article shows how to locate the configuration files for PostgreSQL database on Ubuntu. PostgreSQL JoinHow to Left Join Lateral in PostgreSQLThis article is about the left join lateral in PostgreSQL. PostgreSQL VariableHow to Declare a Variable in a PostgreSQL QueryThis article teaches the reader how to create variables in PostgreSQL and use them to query the database. PostgreSQL DateHow to Cast String to Date DD/MM/YYYY in PostgreSQLThis article shows how we can retrieve dates using a desired format in PostgreSQL. PostgreSQL MathHow to Round an Average to 2 Decimal Places in PostgreSQLThis article describes how to round an average in PostgreSQL to 2 decimal places. PostgreSQL ExitHow to Exit From the Command Line Utility in PostgreSQLThis article describes how to exit from the Psql command line utility in PostgreSQL. PostgreSQL ConnectionHow to Terminate a PostgreSQL ConnectionThis article describes how to terminate an opened connection in PostgreSQL. PostgreSQL CSVHow to Save PL/pgSQL Output From PostgreSQL to CSVThis article describes how to save the PL/pgSQL output from PostgreSQL to a CSV file. PostgreSQL QueryHow to Run PostgreSQL Queries in PSQLThis article describes how to run Queries from the PostgreSQL Command Line Tool. PostgreSQL TableHow to Rename a Table Inside a Schema in PostgreSQLThis article describes renaming a table inside a schema in PostgreSQL. PostgreSQL TableHow to Create a Pivot Table in PostgreSQLThis article describes how to create a pivot table in PostgreSQL. PostgreSQL RowHow to Select Random Rows in PostgreSQLThis article teaches about the different ways we can select random rows in PostgreSQL. PostgreSQL CommentHow to Comment Characters in PostgreSQLThis article explains us about the process of commenting characters in PostgreSQL. PostgreSQL RoleHow to Create Role or User if It Does Not Exist in PostgreSQLThis article teaches how to create a PostgreSQL role for the first time. PostgreSQL ConfigurationHow to Configure PostgreSQL in LinuxThis article teaches how to configure and use PostgreSQL for the first time in Linux. PostgreSQL QueryHow to Write Case-Insensitive Queries in PostgreSQLThis article teaches how to write case-insensitive queries in PostgreSQL . PostgreSQL ServerHow to Start PostgreSQL Server on WindowsThis article teaches how to start a PostgreSQL server on Windows. PostgreSQL FunctionHow to PostgreSQL DATE_TRUNC() FunctionUsing the DATE_TRUNC() function you can define the precision of datetime in Postgres.