How to set up Search_path in the Greenplum database

Failed to connect Greenplum with the report tool, there is no error in the report schema. The Search_path should be set up after judgment.

1) Connection Greenplum

C:\windows\system32>psql-h 1.2.345.678-p 5432-d tpc_1-u gpuser

2) View Search_path

tpc_1# show Search_path;

3) Modify Search_path

tpc_1=# ALTER DATABASE tpc_1 set Search_path to "$user", Public, "My_schema";

4) Exit

tpc_1=# \q

5) Connection Greenplum

C:\windows\system32>psql-h 1.2.345.678-p 5432-d tpc_1-u gpuser

6) View Search_path

tpc_1# show Search_path;

Note 1: If you have a capital letter with double quotes, such as "My_schema",

NOTE 2: After exiting to see the changes take effect.

Note 2:1.2.345.678 is the IP address, 5432 is the port number, Tpc_1 is the library name, Gpuser is the user name