Greenplum Management Mode

Greenplum management mode is the same as oracle schema. It is used to logically organize the storage containers of database objects. Different schemas do not share namespaces. Schema public is created by default after the database is created. each user has the permission to create an object in this schema. If no schema is specified, it is created here by default. You are advised to modify the default search path after creating the schema. Otherwise, you must specify the path for each login to use the created schema. Gtlions = # create schema gtlions authorization gtlions; CREATE SCHEMAgtlions = # alter role gtlions set search_path = gtlions; ALTER entity = # \ dn List of schemas Name | Owner entity + --------- gp_toolkit | gpadmin gtlions | gtlions information_schema | gpadmin entity | gpadmin pg_catalog | gpadmin pg_toast | gpadmin public | gpadmin (8 rows) gtlions = # show search_paht; ERROR: unrecognized configuration parameter "search_paht" gtlions = # show search_path; search_path ----------- gtlions (1 row) gtlions = # select current_schema (); current_schema -------------- gtlions (1 row) gtlions = # select * from pg_namespace; nspname | nspowner | nspacl authorization + ---------- + export gp_toolkit | 10 | {gpadmin = UC/gpadmin, = U/gpadmin} pg_toast | 10 | pg_bitmapindex | 10 | gtlions | 98690 | pg_aoseg | 10 | pg_catalog | 10 | {gpadmin = UC/gpadmin, = U/gpadmin} public | 10 | {gpadmin = UC/gpadmin, = UC/gpadmin} information_schema | 10 | {gpadmin = UC/gpadmin, = U/gpadmin} (8 rows)-EOF-