How to select columns of a table whom column name end with '_old' in postgresql

Asked May 31 '19 at 10:18

Active May 31 '19 at 10:18

Viewed 188 times

I want to insert values into a table whoz table column name end with "_old"

INSERT INTO table_name VALUES(1,2,3) WHERE column LIKE '%_old%' doesn't work

asked May 31 '19 at 10:18

Akshay Kumar

1

You would probably need to write a stored procedure to do this, because you would need to build the query dynamically. Your current approach will not work. – Tim Biegeleisen May 31 '19 at 10:21
i am doing this in a plpgsql function to later bind it to a trigger – Akshay Kumar May 31 '19 at 10:22
Possible duplicate of [Find all tables containing column with specified name - MS SQL Server](https://stackoverflow.com/questions/4849652/find-all-tables-containing-column-with-specified-name-ms-sql-server) – Pribina May 31 '19 at 10:23
CREATE OR REPLACE FUNCTION public.generic_trigger_function() RETURNS trigger AS $BODY$ BEGIN IF (TG_OP = 'INSERT') THEN INSERT INTO person_audit VALUES(OLD.*) name LIKE '%_old%'; END; $BODY$ LANGUAGE plpgsql; – Akshay Kumar May 31 '19 at 10:23
1

@Pribina This question is tagged with Postgres, _not_ SQL Server. – Tim Biegeleisen May 31 '19 at 10:23
Read about the information schema tables. You will probably have to use them here. – Tim Biegeleisen May 31 '19 at 10:23
I didnt get you – Akshay Kumar May 31 '19 at 10:27
`insert into table_name (col1_old, col2_old, col3_old) values (1,2,3);` – May 31 '19 at 10:29
i have many columns like that this approach wont work – Akshay Kumar May 31 '19 at 10:32
We'll need more details. How do you know how many values to insert per table? – Jeremy May 31 '19 at 11:39

0 Answers0