Syntax for adding a timestamp column in Postgres

Follow the simple solution as below:

ALTER TABLE microwaves ADD COLUMN scanned_in timestamp with time zone;

For more details check PostgreSQL - ADD COLUMN

You just had the syntax wrong. You don't need the [DATA] TYPE part here (that's only needed when you want to change the type) :

CREATE TABLE barf
        ( id serial PRIMARY KEY);

ALTER TABLE barf ADD COLUMN scanned_in timestamp with time zone;

BTW (just a hint): most of the ALTER syntax just mimics the syntax for CREATE TABLE (...): the sub-syntax is mostly the same.

Related