How can I select all values that have a number of n or more digits in Postgres?

Question

Let's say I have the follwing column in Postgres:

Id | Column
----------------
1  | AB1234
2  | DE123456
3  | 123456A
4  | 123 A 456
5  | 987654-123
6  | \documents

The query I have only outputs id 6, but I need it to output ids 2,3,5:

SELECT * FROM table WHERE Column SIMILAR TO '%(\d{5,})%'

Your query works fine for me (pg 11.1). What is the actual problem/question? — pirho, Feb 18 '19 at 13:12
It takes \d as literal, so in the example above it outputs "6 | \documents" — joseagaleanoc, Feb 18 '19 at 13:17

score 0 · Answer 1 · answered Feb 18 '19 at 13:18

0

I got it to work with:

SELECT * FROM table WHERE Column SIMILAR TO '%[0-9]{5,}%'

The query on the question for some unknown reason takes \d as a literal string

answered Feb 18 '19 at 13:18

joseagaleanoc

1 Answers1