0

I've looked at the documentation on postgresql, and I can't figure out why my CREATE TABLE is not running.

CREATE TABLE comments
(
    content VARCHAR(100),
    changed_at TIMESTAMP DEFAULT NOW() ON UPDATE SET CURRENT_TIMESTAMP
)

Is there a way to format this so it will work? Thanks in advance..

Improve this question
2
  • Where in the manual did you find that syntax? Commented Aug 17, 2022 at 19:44
  • No. The only way to do this is with a trigger. Commented Aug 17, 2022 at 19:44
Related questions
4346
UPDATE from a SELECT
1040
psql: FATAL: database "<user>" does not exist
1462
Which version of PostgreSQL am I running?
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.