# PostgreSQL > Part of Prisma's Data Guide. The complete index is at https://www.prisma.io/dataguide/llms.txt. Canonical URL: https://www.prisma.io/dataguide/postgresql Content revision: 91b5ea3b95a0824bcd0e0d61f68d6121c6e45039fde2b5f874c4c65eec29030e Source revision: b6716699f6439c3ba6ae3bf7116b7da84963c978 ## Overview PostgreSQL is a feature rich object-relational database that offers incredible power and flexibility while maintaining standards compliance. Learn how to configure and use PostgreSQL to take advantage of its best features. ## In this section - [The benefits of PostgreSQL](https://www.prisma.io/dataguide/postgresql/benefits-of-postgresql.md) - [Getting to know PostgreSQL](https://www.prisma.io/dataguide/postgresql/getting-to-know-postgresql.md) - [5 ways to host PostgreSQL databases](https://www.prisma.io/dataguide/postgresql/5-ways-to-host-postgresql.md) - [Setting up a local PostgreSQL database](https://www.prisma.io/dataguide/postgresql/setting-up-a-local-postgresql-database.md) - [How to configure PostgreSQL on Amazon RDS for production](https://www.prisma.io/dataguide/postgresql/setting-up-postgresql-on-rds.md) - [Connecting to PostgreSQL databases](https://www.prisma.io/dataguide/postgresql/connecting-to-postgresql-databases.md) - [Authentication and authorization](https://www.prisma.io/dataguide/postgresql/authentication-and-authorization.md) - [How to create and delete databases and tables in PostgreSQL](https://www.prisma.io/dataguide/postgresql/create-and-delete-databases-and-tables.md) - [An introduction to PostgreSQL data types](https://www.prisma.io/dataguide/postgresql/introduction-to-data-types.md) - [An introduction to PostgreSQL column and table constraints](https://www.prisma.io/dataguide/postgresql/column-and-table-constraints.md) - [Working with dates in PostgreSQL](https://www.prisma.io/dataguide/postgresql/date-types.md) - [Inserting and modifying data](https://www.prisma.io/dataguide/postgresql/inserting-and-modifying-data.md) - [Reading and querying data](https://www.prisma.io/dataguide/postgresql/reading-and-querying-data.md) - [Short guides](https://www.prisma.io/dataguide/postgresql/short-guides.md)