Problem description
Recently, I rebuilt a database and found that the schema must be specified, otherwise the table cannot be found. Such as public. Macount.
The solution
I changed the default schema setting, so public is not the default. Open postgresql.conf and modify the following statements.
search_path = '"$user", public' # schema names. Add public as the default
Copy the code