menu
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".