May 2018
Intermediate to advanced
576 pages
30h 25m
English
Our task is to run an SQL statement using this form, with X as the table name, against each of our three test tables:
ALTER TABLE X ADD COLUMN last_update_timestamp TIMESTAMP WITH TIME ZONE;
The steps are as follows:
postgres=# SELECT relname FROM pg_class c JOIN pg_namespace n ON c.relnamespace = n.oid WHERE n.nspname = 'test';
relname --------- a b c (3 rows)