I have a table column which contains following text data:
"drop table log_history_2_2015"
"drop table log_history_3_2015"
"drop table log_history_4_2015"
"drop table log_history_5_2015"
"drop table log_history_6_2015"
How can I execute them in single shot without looping through all these rows and executing them individually.
A more general solution is to use a DO block to execute the dynamic SQL:
DO
LANGUAGE plpgsql
$$
DECLARE
stmt text;
BEGIN
FOR stmt IN
SELECT statement FROM the_table
LOOP
EXECUTE stmt;
END LOOP;
END;
$$;
Note that this runs in a single transaction.
Do block would be same one line for execute
use SELECT string_agg(COLUMN_NAME,';')||chr(10) - it will give you single line to run
||chr(10) in query?||chr(10) brakes single line to miltiples - adds tens ASCCI char after semicolonchr(10) is the ASCII line-feed. You can also write it as E'\r' in PostgreSQL. This code appends a single line feed at the end of the whole series of statements. If you want one after each semicolon you need to move the ||chr(10) inside the function call. I would instead write the delimiter as E';\r' or simply include a literal linefeed.