How can I use concat in Greenplum

Question

I have a function where I must concat 'text'||'#'||column_name How can I concat in my query using following script?

p_sql_text := '
       select
            ''MDMP'' as bk_src_cd,
            ''MDMP'||'#'||'counterparty_id as bk_id
       from stg.t_zk3_'|| p_table_name

When I run my workflow in airflow I have the following error:

ERROR loading table:unterminated quoted string at or near "'MDMP#counterparty_id as bk_id

From airflow log:

select 
        'MDMP' as bk_src_cd,
        'MDMP#counterparty_id as bk_id
           from stg.t_zk3_865445fgf5654f) tmp

Answer 1

This method is working ''MDMP''||''#''||counterparty_id as bk_id