Selecting columns whose name matches a regular expression in PostgreSQL

postgresql, regex

Solution

You will need to write a dynamic `sql('select '||colname||' from (yourtable)')` to accomplish this and dynamic sql should have supplied column names from the following sql:

SELECT column_name 
    FROM information_schema.columns 
    WHERE table_name = '<your table>' 
    AND column_name LIKE '<beginning of column name>%';

Problem

How can I select only those columns whose name matches a regular expression in PostgreSQL? For example, how do I select only the columns whose name begins with 'A' in the following table, without explicitly enumerating them in the select list? ``` id A1 A2 A3 A4 A5 B 1 a b c d e f 2 g h i j k l ```

Original source