This task is regarding developing a shell script on checking-up the PostgreSQL installation. I lack expertise in doing shell scripting. So, can you please help me in developing this task please.
Operating system: RHEL 6.3
PostgreSQL Version: 9.3
There, are two types of queries that are executed in my app:
DELETE FROM tbl1 WHERE user_id = 1;
INSERT INTO tbl1 VALUES (...), (...), ...;
UPDATE tbl2 WHERE id = 1 SET ...;
DELETE FROM tbl3 WHERE tbl2_id = 1;
INSERT INTO tbl3 VALUES (...), (...), ...;
DELETE FROM tbl4 WHERE tbl2_id = 1;
@AndriyM "a junction table is a database table that contains common fields from two or more other database tables within the same database. It is on the many side of a one-to-many relationship with each of the other tables."