Try just using the string function “position”. You’ll need to check the documentation or wait for others to determine which specific system views you will need to obtain the column name (if you do not already know that part).
Non-Zero (or maybe >= 0) indicates the substring was found – though I would test with some known sample data just to make sure before running it on the column names. Dave From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of akp geek Hi all - I am trying to write a query to find all the column names in database that has a underscore in it (_) example souce_id. I know like will not work , if where column_name like '%_%' Can you please help? Regards |
