Horton

pg_class has a relnamespace column. You can create and access tables

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 1dbf8aa7a8159875bb46f6ee6ab0116eee76869b
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2002-03-26T19:17:02Z
Releases: 7.3.1 
pg_class has a relnamespace column.  You can create and access tables
in schemas other than the system namespace; however, there's no search
path yet, and not all operations work yet on tables outside the system
namespace.

Files

PathChange+/−
doc/src/sgml/catalogs.sgml modified +10 −1
src/backend/access/heap/heapam.c modified +82 −19
src/backend/access/index/indexam.c modified +31 −6
src/backend/bootstrap/bootparse.y modified +9 −4
src/backend/bootstrap/bootstrap.c modified +9 −9
src/backend/catalog/aclchk.c modified +12 −10
src/backend/catalog/genbki.sh modified +10 −1
src/backend/catalog/heap.c modified +31 −87
src/backend/catalog/index.c modified +31 −57
src/backend/catalog/indexing.c modified +2 −2
src/backend/catalog/Makefile modified +2 −2
src/backend/catalog/namespace.c added +126 −0
src/backend/commands/cluster.c modified +35 −24
src/backend/commands/command.c modified +57 −61
src/backend/commands/comment.c modified +17 −12
src/backend/commands/creatinh.c modified +32 −30
src/backend/commands/indexcmds.c modified +42 −32
src/backend/commands/rename.c modified +18 −14
src/backend/commands/trigger.c modified +9 −9
src/backend/commands/user.c modified +4 −4
src/backend/executor/execMain.c modified +10 −6
src/backend/parser/analyze.c modified +15 −18
src/backend/parser/parse_clause.c modified +2 −2
src/backend/parser/parse_relation.c modified +2 −2
src/backend/rewrite/rewriteDefine.c modified +2 −2
src/backend/tcop/utility.c modified +63 −55
src/backend/utils/adt/acl.c modified +15 −14
src/backend/utils/cache/catcache.c modified +4 −4
src/backend/utils/cache/lsyscache.c modified +20 −3
src/backend/utils/cache/relcache.c modified +113 −119
src/backend/utils/cache/syscache.c modified +9 −9
src/include/access/genam.h modified +4 −2
src/include/access/heapam.h modified +6 −3
src/include/bootstrap/bootstrap.h modified +2 −2
src/include/catalog/catversion.h modified +2 −2
src/include/catalog/heap.h modified +6 −5
src/include/catalog/index.h modified +3 −2
src/include/catalog/indexing.h modified +3 −3
src/include/catalog/namespace.h added +26 −0
src/include/catalog/pg_attribute.h modified +47 −45
src/include/catalog/pg_class.h modified +35 −33
src/include/commands/cluster.h modified +2 −2
src/include/commands/command.h modified +3 −4
src/include/commands/comment.h modified +2 −2
src/include/commands/defrem.h modified +5 −5
src/include/commands/rename.h modified +2 −2
src/include/nodes/parsenodes.h modified +2 −43
src/include/nodes/primnodes.h modified +43 −2
src/include/utils/catcache.h modified +5 −5
src/include/utils/lsyscache.h modified +2 −1
src/include/utils/relcache.h modified +5 −3
src/include/utils/rel.h modified +9 −1
src/include/utils/syscache.h modified +2 −2
src/pl/plpgsql/src/pl_comp.c modified +22 −21