Hi there,
I would like to get a list of all tables in my schema which begin with "in_". But as the "underscore (_) in pattern stands for (matches) any single character", my query:
SELECT * FROM pg_tables WHERE schemaname='public' AND tablename LIKE 'in_%' ORDER BY tablename ASC
doesn't exactly do what I want.
It retrieves me tables like this one (which is what I want):
in_water_use_ind
but also tables like this one (which is not what I want):
ind_gdp
I am sure this is just a minor thing. But I have no idea how to solve it.
Thanks for any hints!
Stef