Data Types in PostgreSQL: Learning PostgreSQL with Grant
PostgreSQL has an unusually large number of data types. Grant Fritchey reviews each data type and discusses the good and bad points of each.
2022-03-30
PostgreSQL
How to back up and restore in PostgreSQL: Learning PostgreSQL with Grant
You can perform PostgreSQL backups with the pg_dump command. In this article, Grant Fritchey explains how to back up and restore with the pg_dump and pg_restore utilities.
2022-03-04
PostgreSQL in Azure using the Azure Data Studio Extension
Learn how to create a PostgreSQL database and work with it from Azure Data Studio.
2022-02-07
2,348 reads
Creating a Database and Tables in PostgreSQL: Learning PostgreSQL with Grant
The syntax for creating databases and tables in PostgreSQL is similar to other RDBMS. In this article, Grant Fritchey shows how to create databases and tables.
2022-01-31
PostgreSQL in Azure Data Studio
Learn how to install PostgreSQL and using Azure Data Studio to work with it.
2022-01-31
5,434 reads
Connecting to PostgreSQL: Learning PostgreSQL with Grant
Database professionals often work with more than one database platform. Grant Fritchey explains setting up and connecting to PostgreSQL database.
2021-12-17
PostgreSQL Date And Time Part 2
In the second part of this PostgreSQL date time series, we examine a number of commonly used functions for getting current dates and times and converting strings to dates and times.
2021-09-22
1,847 reads
Array and Custom Data Types in PostgreSQL
Introduction Just like every other database, PostgreSQL has its own set of basic datatypes, like Boolean, Varchar, Text, Date, Time, etc. We can easily store data like numbers, characters, date, time, etc. using these supported datatypes, but what if we need to store multiple data elements in a single column? Suppose we are storing the […]
2021-09-10
8,775 reads
PostgreSQL Date And Time Part 1
This article shows the basics of using the age, and current date/time functions in PostgreSQL.
2021-08-09
2,010 reads
Getting a Query Execution Plan in PostgreSQL
Introduction You often need to check the performance of a PostgreSQL query you just wrote to look for some way to improve performance. In order to do this, you need a report of the query execution, which is called the execution plan). The query execution plan gives you the entire summary of the query execution […]
2021-03-18
6,125 reads
Blogs
Summit Launch Pricing Ends June 7
By Steve Jones
The PASS Data Community Summit is back in Seattle this November, the 14-17, 2023....
Masking Columns in Azure SQL and SQL Server: Safeguarding Sensitive Data
Information security and privacy are key in today’s data-driven world. Sensitive data needs to...
Tales From The Field Weekly Wrap Up for the Week of 05-22-2023 Microsoft Fabric Launch & Moving Home Offices
By SQLBalls
Hello Dear Reader! Sorry this is so late, moving houses has gotten me a...
Forums
You have an error in your SQL syntax; check the manual that corresponds
I am having great trouble creating a data pipeline using MariaDB connector 3 with...
Availability Group database went into 'Restoring' state
Dear Friends, Please advise why would one of my Availability Group databases go into...
Access db
Access db wanting to move sql server, how much control does business have over...
Ask SSC