How to Solve MYSQL ERROR: relation “table_name” does not exist

ERROR: relation "activities" does not exist

image.png

In conclusion, aligning the username and schema name will solve the problem.

1. Show search path.

SHOW search_path;

If you check with

$user, public

image.png

Since user is public, use the schema name.

2. Set schema name.

set search_path to schema_name;

Read More:

Leave a Reply

Your email address will not be published. Required fields are marked *