Editing Database Schema

[[wikipedia:Database schema]] are analogous to [[directories]] at the operating system level, except that schemas cannot be nested. <ref>https://www.postgresql.org/docs/current/ddl-schemas.html</ref>
Typical schemas usage scenarios <ref> https://www.postgresql.org/docs/current/ddl-schemas.html</ref>:
* To allow many users to use one database without interfering with each other.
* To organize database objects into logical groups to make them more manageable.
* Third-party applications can be put into separate schemas so they do not collide with the names of other objects.

== Example ==
* [[CREATE SCHEMA]]

Grant examples on schemas: 
* <code>[[GRANT USAGE]] ON [[ALL SEQUENCES IN SCHEMA]] your_schema TO mygrp;</code><ref>https://stackoverflow.com/a/10353730</ref>
* <code>[[GRANT USAGE ON]] [[SCHEMA]] your_schema TO [[GROUP]] your_group;</code>

* Show/List [[schema]]s:
** <code>select [[nspname]] from [[pg_catalog]].pg_namespace;</code> 
** <code>select [[schema_name]] from [[information_schema]].schemata;</code> <ref>https://dba.stackexchange.com/questions/40045/how-do-i-list-all-schemas-in-postgresql</ref>
** <code>[[\dn]]</code>
** <code>[[\dn+]]</code>

[[PostgreSQL]]: <code>[[pg_catalog]]</code> and <code>[[public]]</code>.


 [[GRANT SELECT]] ON ALL [[TABLES]] IN [[SCHEMA]] [[public]] TO xxx;

== Related ==
* [[Liquibase]]
* [[PostgreSQL]], [[Amazon Redshift]]
* [[GRANT]]
* [[PostgreSQL: Database roles|Role]]
* [[PostgreSQL: catalogs]]
* <code>[[GRANT SELECT]]</code>
* [[Index]], [[Table]], [[Schema]], [[Sequence]], [[Views]]
* <code>SET [[search_path]]</code>, <code>[[SHOW search_path]]</code>

== See also ==
* {{PostgreSQL}}

[[Category:PostgreSQL]]
@@ Line 5: / Line 5: @@
 * Third-party applications can be put into separate schemas so they do not collide with the names of other objects.
- public or default
+== Example ==
+* [[CREATE SCHEMA]]
-== Examples ==
-* <code>[[CREATE SCHEMA]]</code>
 Grant examples on schemas:
@@ Line 23: / Line 21: @@
-  [[GRANT SELECT ON ALL TABLES]] IN [[SCHEMA]] [[public]] TO xxx;
+  [[GRANT SELECT]] ON ALL [[TABLES]] IN [[SCHEMA]] [[public]] TO xxx;
- [[ALTER DEFAULT PRIVILEGES]] IN SCHEMA public GRANT SELECT ON TABLES TO xxx;
- [[GRANT ALL PRIVILEGES ON SCHEMA]]
-== Errors ==
-* [[ERROR: permission denied for schema public]]
 == Related ==
@@ Line 41: / Line 31: @@
 * <code>[[GRANT SELECT]]</code>
 * [[Index]], [[Table]], [[Schema]], [[Sequence]], [[Views]]
-* <code>[[SET]] [[search_path]]</code>, <code>[[SHOW search_path]]</code>
+* <code>SET [[search_path]]</code>, <code>[[SHOW search_path]]</code>
-* <code>[[GRANT ON ALL TABLES]]</code>
-* <code>[[schema_name]]</code>
-== News ==
-* Oct 2022 [[PostgreSQL 15]], revokes the [[CREATE]] permission from all users except a database owner from the [[public]] (or default) schema
 == See also ==
-* {{Schema}}
+* {{PostgreSQL}}
 [[Category:PostgreSQL]]