Need to extract only the values in the field

[AshwinKumar AshwinKumar]

Hi Team,

I have an elasticsearch view called zips . Below is the table data -

0: jdbc:calcite:model=./elasticsearch2/src/te> select POP from
"elasticsearch".ZIPS;
+----------------------+
|         POP          |
+----------------------+
| {POP=13367}          |
| {POP=1652}           |
| {POP=3184}           |
| {POP=43704}          |
| {POP=2084}           |
| {POP=1350}           |
| {POP=8194}           |
| {POP=1732}           |
| {POP=9808}           |
| {POP=4441}           |
+----------------------+
10 rows selected (0.319 seconds)

Could you please let me know if there is a way to select only the values in
POP field using SQL. Like for eg I need only the integer values like
13367,1652 and so on from the tables. I need to join these values with
another table in postgres schema.

Thanks,
Ashwin