Brave Search

free and open-source relational database management system

POHST-gres-kew-EL), also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) properties, automatically updatable … Wikipedia

Factsheet

People also ask

What are the benefits of using PostgreSQL?

PostgreSQL has a rich history of supporting advanced data types. It supports a level of performance optimization that is common across its commercial database counterparts, like Oracle and SQL Server. Read more benefits below.

aws.amazon.com

aws.amazon.com › amazon rds › amazon rds for postgresql › what is postgresql

What is PostgreSQL? - PostgreSQL Explained - AWS

General purpose OLTP database

PostgreSQL has superior online transaction processing capabilities (OLTP) because you can configure it for automatic failover and full redundancy. Financial institutions, manufacturers. startups, and large enterprises use PostgreSQL as the primary data store to support their internet-scale applications, solutions, and products.

aws.amazon.com

aws.amazon.com › amazon rds › amazon rds for postgresql › what is postgresql

What is PostgreSQL? - PostgreSQL Explained - AWS

Federated database

PostgreSQL's Foreign Data Wrappers and JSON support allow it to link with other data stores—including NoSQL types. As a result, it can act like a federated hub for polyglot database systems that use different database technologies for varying use cases.

aws.amazon.com

aws.amazon.com › amazon rds › amazon rds for postgresql › what is postgresql

What is PostgreSQL? - PostgreSQL Explained - AWS

Google Cloud

cloud.google.com › discover › what-is-postgresql

What Is PostgreSQL? Databases Explained | Google Cloud

Postgres began in 1986 as an evolution of Ingres, a previous database from the University of California, Berkeley. Since 1994, it has used Structured Query Language (SQL) for queries and transactions—and it has been continuously updated by a community of individual and corporate developers. This long history of development and use of SQL makes PostgreSQL one of the most popular open source databases worldwide, with every major cloud vendor offering PostgreSQL or PostgreSQL-derived databases as a service.

Neon

neon.com › postgresql › administration › show-databases

PostgreSQL Show Databases

In this tutorial, you will learn how to show databases in a PostgreSQL server using psql and pg_database catalog.

Wikipedia

en.wikipedia.org › wiki › PostgreSQL

PostgreSQL - Wikipedia

4 days ago - POHST-gres-kew-EL), also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) properties, automatically updatable views, ...

History Multiversion concurrency control (MVCC)Storage and replication Control and connectivity Security Standards compliance Benchmarks and performance Platforms Database administration Notable users Service implementations Release history Ecosystem and Derivatives Further reading

Atlassian

atlassian.com › data › admin › how to list databases and tables in postgresql using psql

How to List databases and tables in PostgreSQL using psql

Most Postgres servers have three databases defined by default: template0, template1 and postgres. template0 and template1 are skeleton databases that are or can be used by the CREATE DATABASE command. postgres is the default database you will ...

Find elsewhere

Google Bing Mojeek

Prisma

prisma.io › postgres

Prisma Postgres | Serverless PostgreSQL with Instant Setup

Create a serverless PostgreSQL database in seconds with built-in connection pooling, global availability, automated backups, and usage-based pricing.

IBM

ibm.com › think › topics › postgresql

What Is PostgreSQL? | IBM

December 24, 2025 - PostgreSQL is an open source database with a well-deserved reputation for speed, reliability, flexibility and support of open standards.

Stack Overflow

stackoverflow.com › questions › 37377642 › how-to-list-databases-in-terminal-in-postgressql

postgresql - How to list databases in terminal in PostgresSQL? - Stack Overflow

Top answer

1 of 3

Thanks to @Michał Sznurawa for pointing me in the right direction - from the Mac terminal, using psql -l, rather than psql \l does the trick.

2 of 3

This lists all databases:

SELECT datname FROM pg_database;

These list all databases in detail:

\list

\l

These list all databases in more detail:

\list+

\l+

Microsoft Azure

azure.microsoft.com › en-us › products › postgresql

Azure Database for PostgreSQL | Microsoft Azure

Save up to 58%1 in TCO compared to on-premises and self-managed PostgreSQL environments by eliminating hardware expenses, consolidating database operations, automating routine tasks, and simplifying architecture.

Supabase

supabase.com › database

Database | Supabase

Every Supabase project is a full Postgres database with realtime functionality, fine-grained access controls, and instant APIs — no extra configuration required.

EnterpriseDB

enterprisedb.com › downloads › postgres-postgresql-downloads

EDB: Open-Source, Enterprise Postgres Database Management

It is an object-oriented database that is fully ACID compliant and highly extensible, enabling the community to add new features and capabilities as workload demands evolved. Because of its extensibility, PostgreSQL offers a wide variety of built-in PostgreSQL data types including JSON, XML, HSTORE (key-value), Geo-spatial (PostGIS), IPv6; flexible indexing, featuring composite indexes, GiST, SP- GiST, GIN; full Text Search, online index reorganization; background workers such as a managed process known as Mongress, which accepts MongoDB queries to interface with Postgres data; a contrib module interface: pgcrypto (data encryption), pg_trgm (find 'similar' data), HSTORE (schema-less data); and extensive SQL support.

IBM

ibm.com › home › products › ibm cloud databases for postgresql

IBM Cloud Databases for PostgreSQL

IBM Cloud® Databases for PostgreSQL is a fully managed service enabling you to efficiently create sophisticated, high-performance applications with enhanced JSON support and improved query parallelism.

ITG EU

eu.itglobal.com › glossary › postgresql

PostgreSQL: database management system, features | ITG EU

March 25, 2024 - PostgreSQL is a database management system distributed for free as an open-source product. Unlike other free databases, PostgreSQL is an object-relational database.

Stack Exchange

dba.stackexchange.com › questions › 191767 › how-to-see-the-list-of-the-postgres-databases-via-the-linux-terminal

postgresql - How to see the list of the Postgres databases via the linux terminal? - Database Administrators Stack Exchange

November 27, 2017 - If you only want to see the list of databases and have psql available to you, you can simply use -l to list and exit.

DEV Community

dev.to › franckpachot › mongodb-query-planner-io2

MongoDB Query Planner - DEV Community

April 7, 2026 - #architecture #database #performance #postgres Extended RUM in DocumentDB extension for PostgreSQL: Efficient ESR (Equality, Sort, Range) Queries

DBeaver

dbeaver.io

DBeaver Community | Free Open-Source Database Management Tool

DBeaver Community is a free, open-source database management tool recommended for personal projects. Manage and explore SQL databases like MySQL, MariaDB, PostgreSQL, SQLite, Apache Family, and more.

Red Gate Software

red-gate.com › home › creating a database and tables in postgresql: learning postgresql with grant

Creating a Database and Tables in PostgreSQL: Learning PostgreSQL with Grant | Simple Talk

April 16, 2024 - Since I know SQL Server, I’m going to compare what’s going on here, to what’s going on there. In SQL Server, you have a system database called model used as a template when you create a new database. In PostgreSQL, the same thing happens, but the database is called template1.

Softnet-hosting

softnet-hosting.com › terminology › pgsql-databases

PostgreSQL Databases

PostgreSQL is a powerful open-source database control system, which has been growing in level of popularity lately as a result of its stability and dependability. It comes with many advanced features and it could be used to save any sort of info.

W3Schools

w3schools.com › postgresql

PostgreSQL Tutorial

PostgreSQL is an advanced, free, and open-source relational database system.