SELECT*EXCLUDEcol_aRENAMEcol_bASalias_b... SELECT*EXCLUDEemployee_idREPLACE('DEPT-'||department_idASdepartment_id)... You cannot specify the same column inEXCLUDEandRENAME. If you specifyILIKEwithRENAMEorREPLACE, you must specifyILIKEfirst: ...
createtableusers (id serialprimarykey,-- Auto incrementing IDsnamecharactervarying,-- String column without specifying a lengthpreferences jsonb,-- JSON columns are great for storing unstructured datacreated_attimestampwithouttimezone-- Always store time in UTC); ...