[GENERAL] Underscore "_" in LIKE pattern

[Stefan Schwarzer]

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