News, articles, customer success stories, and tutorials on PostgreSQL, open source, EDB, and more
Exploring Eliminating the ORM from Your Next PostgreSQL ApplicationTom Kincaid—2/23/2021
In this post, Tom Kincaid will cover one of the chapters I found especially interesting. It is about a programming methodology called NORM.
PostgreSQL vs. SQL Server (MSSQL) - Extremely Detailed ComparisonEDB Team—7/30/2020
Learn the differences between SQL Server and PostgreSQL Database. Compare syntax, data types, functions, and many more. Comparison of MSSQL vs. PostgreSQL performance and ease of use. Which is better?
How to load a sample database with schemas and data in PostgreSQLArun Gavhane—3/23/2020
This article discusses how to make a backup of a database using pg_dump in PostgreSQL and provides examples of how to make and restore the backups in different formats.
How NULL and empty strings are treated in PostgreSQL vs OracleThom Brown—2/12/2020
This article discusses the differences between how Oracle and PostgreSQL evaluate NULL characters and empty strings. Oracle reads empty strings as NULLs, while PostgreSQL treats them as empty. Concatenating NULL values with non-NULL characters results in that character in Oracle, but NULL in PostgreSQL.
How to sort rows using ORDER BY and SELECT in PostgreSQL: 6 ExamplesArun Gavhane—2/7/2020
<p>This article reviews five ways to sort table data using the ORDER BY clause together with the SELECT statement in PostgreSQL.</p>
Examples of using GREATEST and LEAST functions in PostgreSQLTushar Ahuja—12/30/2019
<p>This article discusses the conditional expressions GREATEST and LEAST in PostgreSQL and gives some examples of their usage.</p>
How to import and export data using CSV files in PostgreSQLAmit Sharma—12/20/2019
<p>This article explains how to import data from a CSV file into PostgreSQL and how to export it back from PostgreSQL to CSV. It includes an introduction to the CSV file format and some examples of its usage.</p>
How to declare variables in PL/pgSQL stored proceduresRajkumar Raghuwanshi—12/19/2019
<p>This article covers how stored procedures can make use of variables to be more functional and useful. After defining PL/pgSQL, stored procedures, and variables, it provides examples of how variables can be used.</p>
PostgreSQL vs. MySQL: A 360-degree Comparison [Syntax, Performance, Scalability and Features]EDB Team—12/11/2019
<p>In this blog, we will discuss the key differences in terms of performance, syntax, scalability, and features between PostgreSQL and Mysql. PostgreSQL and MySQL are both immensely popular open-source databases, and a variety of real-time applications today utilize both. MySQL is known to be the world’s most popular database, whereas PostgreSQL is known as the world’s most advanced RDBMS database.</p>
How to combine multiple queries into a single result set using UNION, INTERSECT, and EXCEPTThom Brown—12/6/2019
<p>This article discusses methods for comparing and combining multiple queries into a single result set in PostgreSQL.</p>
PostgreSQL unique constraint null: Allowing only one NullBruce Momjian—11/7/2019
<p>While the SQL standard allows multiple nulls in a unique column, and that is how Postgres behaves, some database systems (e.g. MS SQL) allow only a single null in such cases. Users migrating from other database systems sometimes want to emulate this behavior in Postgres. Fortunately, this can be done.</p>
How to use pg_dump and pg_restore in multi-host enviormentBruce Momjian—11/7/2019
<p>You have probably looked at logical dumps as supported by pg_dump and restores by pg_restore or, more simply, psql. What you might not have realized are the many options for dumping and restoring when multiple computers are involved.</p>
BigAnimal: Fully managed PostgreSQL in the cloud
BigAnimal features Oracle compatibility, built-in high availability, and 24/7 support from our team of PostgreSQL experts.Learn more
Demo of Oracle SQL compatibility in BigAnimal
BigAnimal lets you run Oracle SQL queries in the cloud via EDB Postgres Advanced Server. Watch the video, or load up psql and follow along.Learn more