How to solve permission denied for schema public

 1.  ERROR: permission denied for schema public

C:\Users\Maxwell Pan>psql -U sam -d nano
Password for user sam:
psql (15.2)
WARNING: Console code page (437) differs from Windows code page (1252)
         8-bit characters might not work correctly. See psql reference
         page "Notes for Windows users" for details.
Type "help" for help.

nano=> create table tree(type varchar(100));
ERROR:  permission denied for schema public
LINE 1: create table tree(type varchar(100));
                     ^
nano=>

2. 切换到postgres超级用户下，进行授权。

nano=> \c nano postgres
Password for user postgres:
You are now connected to database "nano" as user "postgres".
nano=# grant all on schema public to sam;
GRANT
nano=#

3. 切换到 sam用户下进行建表。

nano=# \c nano sam
Password for user sam:
You are now connected to database "nano" as user "sam".
nano=> \d
Did not find any relations.
nano=> create table tree(type varchar(100));
CREATE TABLE
nano=> \d
       List of relations
 Schema | Name | Type  | Owner
--------+------+-------+-------
 public | tree | table | sam
(1 row)


nano=> insert into tree values('this is a olive tree');
INSERT 0 1
nano=>

4. 总结思考：

对于新建立的用户，需要给与相关权限才可以进行CRUD。