# Reading and querying data > Part of Prisma's Data Guide. The complete index is at https://www.prisma.io/dataguide/llms.txt. Reading and querying data in PostgreSQL. Including how to perform basic queries with `SELECT` in PostgreSQL, filter query results in PostgreSQL, and more. Canonical URL: https://www.prisma.io/dataguide/postgresql/reading-and-querying-data Content revision: 91b5ea3b95a0824bcd0e0d61f68d6121c6e45039fde2b5f874c4c65eec29030e Source revision: b6716699f6439c3ba6ae3bf7116b7da84963c978 ## In this section - [How to perform basic queries with \`SELECT\` in PostgreSQL](https://www.prisma.io/dataguide/postgresql/reading-and-querying-data/basic-select.md) - [How to filter query results in PostgreSQL](https://www.prisma.io/dataguide/postgresql/reading-and-querying-data/filtering-data.md) - [Using joins to combine data from different tables in PostgreSQL](https://www.prisma.io/dataguide/postgresql/reading-and-querying-data/joining-tables.md) - [Introduction to optimizing PostgreSQL performance](https://www.prisma.io/dataguide/postgresql/reading-and-querying-data/optimizing-postgresql.md)