[Answered ]-I tried updating django_site row to change the name but I have gotten ERROR: column "alt native" does not exist

by

1👍

✅

In PostgreSQL double quotes (") are used to denoted delimited identifiers, not string literals. Single quotes (') are used for string literals, so you update with:

UPDATE django_site SET name = 'alt native' WHERE id=1;

You probably should also add a WHERE … clause to prevent updating all records.

You should also use name as column, not django_site.name.

👤willeM_ Van Onsem

Leave a comment