Search for a command to run...
Articles tagged with #postgresql
If you’re switching from MySQL to PostgreSQL, you might look for the SHOW TABLES command — only to discover it doesn’t exist here. Fortunately, PostgreSQL gives you equally convenient options for listing all tables. You can use either the PSQL shell ...
Regex is the Swiss-army knife for text. PostgreSQL’s REGEXP_MATCH lets you capture parts of a string directly in SQL, so you can keep parsing close to the data. If you’ve struggled with app-side parsing or clunky string functions, this guide shows ho...
Need to find partial matches or search patterns in SQL? The LIKE operator is the tool for the job. It's your go-to for string-based filtering, offering flexible ways to search using wildcards. In this guide, we’ll cover the syntax, examples, and best...
Foreign keys in PostgreSQL link tables together, ensuring data consistency and preventing disconnected records. They're a key part of enforcing rules in a relational schema. This guide will show you how to use them effectively, write the correct synt...
Working with dates in SQL can be tricky. Each DBMS implements DATE, TIME, DATETIME, and TIMESTAMP slightly differently, often leading to subtle bugs in multi-region applications. This guide outlines these types for MySQL, PostgreSQL, SQL Server, and ...
Full text search is an essential feature for any app dealing with rich textual content. PostgreSQL’s native Full Text Search (FTS) gives you tools to perform fast and accurate searches across multiple fields—with language-aware matching and relevance...
