How to surround a selected value with double quotes? - Mailing list pgsql-novice

Hello,

  I wrote a script to analyze and run vacuum on tables that need it. 

Sadly at the time I wrote the script, I never expected a schema name to be pure numbers. 

So my Script does not work now.

I want to add double quote marks to each schema name and table name select. I tried using the CONCAT function, but it does not work as I expected it to.

I would be grateful if someone can help me understand the mistake I am making with the CONCAT.

Regards

Ram

The table 7464128.locale_7464128 in database data listening on port 5432 with size 303104 must be vacuumed . It has a XID gap of 5616

Use the command psql -p 5432 -d data -c " vacuum freeze 7464128.locale_7464128"

ERROR:  trailing junk after numeric literal at or near "7464128.locale_7464128"

LINE 1:  vacuum freeze analyze 7464128.locale_7464128

                              ^

data=# \dt *.locale_7464128

              List of relations

Schema  |      Name      | Type  |  Owner

---------+----------------+-------+----------

7464128 | locale_7464128 | table | postgres

(1 row)

data=# vacuum freeze analyze 7464128.locale_7464128 ;

ERROR:  trailing junk after numeric literal at or near "7464128.locale_7464128"

LINE 1: vacuum freeze analyze 7464128.locale_7464128 ;

                              ^

data=# vacuum freeze analyze "7464128"."locale_7464128" ;

VACUUM

data=# \q

#Build the SQL needed to get the list of tables that are approaching the SAFE_XID_GAP

LIST_OLDEST_UNFROZEN_XID_SQL=" SELECT   \

       cast (age(PGCL.relfrozenxid) as integer) as GAP, \

       INTB.table_catalog as DB_NAME,   \

       "$PORT_NO" , \

       CONCAT('"',INTB.table_schema,'"') || '.' ||  \

       CONCAT('"',PGCL.relname,'"') as TABLE_NAME,      \

       pg_table_size(PGCL.oid) as TABLE_SIZE \

FROM                                                         \

      pg_class PGCL,                                         \

      information_schema.tables INTB                         \

WHERE                                                        \

     PGCL.relname=INTB.table_name                            \

AND                                                          \

     PGCL.relkind='r'                                       \

AND                                                          \

     age(PGCL.relfrozenxid)  > "$SAFE_XID_GAP" \

ORDER BY                                                    \

        1 DESC ;"