OID of the TOAST table associated with this table, zero if none. It is updated by VACUUM, ANALYZE, and a few DDL commands such as CREATE INDEX. This is only an estimate used by the planner. Number of pages that are marked all-visible in the table's visibility map. If the table has never yet been vacuumed or analyzed, reltuples contains -1 indicating that the row count is unknown. Size of the on-disk representation of this table in pages (of size BLCKSZ). (Not meaningful if the relation has no on-disk file.) If zero, the database's default tablespace is implied. The tablespace in which this relation is stored. Reltablespace oid (references pg_tablespace. Name of the on-disk file of this relation zero means this is a “ mapped” relation whose disk file name is determined by low-level state If this is a table or an index, the access method used (heap, B-tree, hash, etc.) otherwise zero (zero occurs for sequences, as well as relations without storage, such as views) The OID of the data type that corresponds to this table's row type, if any zero for indexes, sequences, and toast tables, which have no pg_type entryįor typed tables, the OID of the underlying composite type zero for all other relations The OID of the namespace that contains this relation Indexes, and spanner_statistics are available.Relnamespace oid (references pg_namespace. Open-source PostgreSQL, such as database_options, index_columns, Some tables that are available with Spanner but not.Supported in PostgreSQL-dialect databases are not available. Tables related to open-source PostgreSQL features that are not.Automatically generated constraint names use a different format than.PostgreSQL-dialect databases use public for the default schema name.Some of the table columns for open-source PostgreSQL are available,īut not populated in PostgreSQL-dialect databases.Other notable differences in the information_schema for PostgreSQL-dialect databases are: The GoogleSQL-specificĬolumns can shift in position if PostgreSQL adds new columns to an Select * and reference columns by offset might not work the same as they doĪgainst open-source PostgreSQL databases. Note: Queries against the information_schema for PostgreSQL-dialect databases that use Modification when using PostgreSQL-dialect databases in Google Cloud CLI. Open-source PostgreSQL version of information_schema should work without Open-source PostgreSQL columns come first and in the same order as they doįor a open-source PostgreSQL database, and any distinct columns for Some cases also include columns from Spanner. The tables in the information_schema for open-source PostgreSQL and in The tables in the information_schema for PostgreSQL-dialect databases include columns from
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |