If you want to match text that ends with "-dev" using a WHERE sentence in PostgreSQL, you can do so using the LIKE operator and the percent sign % as a wildcard. Here's how:
-- Example: Match strings that end with '-dev'
SELECT *
FROM your_table
WHERE your_column LIKE '%-dev';
In this example, the LIKE operator with the pattern "%-dev" will match any strings in your_column that end with "-dev". The percent sign % acts as a wildcard for zero or more characters. So, it matches any text that ends with "-dev".