"=?gb18030?B?zqjSu6Hv?=" <270246512@qq.com> writes:
> After restore the database via pg_restore, the search_path look well and is the same as before restore.
This looks like maybe your user "cm" lacks permissions on the public
schema? If "select current_schemas(true)" doesn't show the public
schema as part of the active search path, that's probably your issue.
"\dn+" is another way to check.
regards, tom lane
