Различия
Показаны различия между двумя версиями страницы.
— | pg_class [2025/07/06 12:39] (текущий) – создано - внешнее изменение 127.0.0.1 | ||
---|---|---|---|
Строка 1: | Строка 1: | ||
+ | ====== pg_class PostgreSQL System Catalogs ====== | ||
+ | * [[PostgreSQL]] | ||
+ | * [[https:// | ||
+ | < | ||
+ | select relname from pg_class; | ||
+ | </ | ||
+ | select * from pg_class where relname like ' | ||
+ | </ | ||
+ | Структура и индексы таблицы pg_class< | ||
+ | =# \d pg_class | ||
+ | Table " | ||
+ | | ||
+ | ----------------+-----------+----------- | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | Indexes: | ||
+ | " | ||
+ | " | ||
+ | </ | ||
+ | |||
+ | ^^Name ^Type ^References ^Description^^ | ||
+ | ||relname |name | |Name of the table, index, view, etc.|| | ||
+ | ||relnamespace |oid |pg_namespace.oid |The OID of the namespace that contains this relation|| | ||
+ | ||reltype |oid |pg_type.oid |The OID of the data type that corresponds to this table' | ||
+ | ||relowner |oid |pg_authid.oid |Owner of the relation|| | ||
+ | ||relam |oid |pg_am.oid |If this is an index, the access method used (B-tree, hash, etc.)|| | ||
+ | ||relfilenode |oid | |Name of the on-disk file of this relation; 0 if none|Имя файла на [[HDD]]; 0 если файл не существует| | ||
+ | ||reltablespace |oid |pg_tablespace.oid |The tablespace in which this relation is stored. If zero, the database' | ||
+ | ||relpages |int4 | |Size of the on-disk representation of this table in pages (of size BLCKSZ). This is only an estimate used by the planner. It is updated by VACUUM, ANALYZE, and a few DDL commands such as CREATE INDEX|| | ||
+ | ||reltuples |float4 | |Number of rows in the table. This is only an estimate used by the planner. It is updated by VACUUM, ANALYZE, and a few DDL commands such as CREATE INDEX|| | ||
+ | ||reltoastrelid |oid |pg_class.oid |OID of the TOAST table associated with this table, 0 if none. The TOAST table stores large attributes "out of line" in a secondary table|| | ||
+ | ||reltoastidxid |oid |pg_class.oid |For a TOAST table, the OID of its index. 0 if not a TOAST table|| | ||
+ | ||relhasindex |bool | |True if this is a table and it has (or recently had) any indexes. This is set by CREATE INDEX, but not cleared immediately by DROP INDEX. VACUUM clears relhasindex if it finds the table has no indexes|| | ||
+ | ||relisshared |bool | |True if this table is shared across all databases in the cluster. Only certain system catalogs (such as pg_database) are shared|| | ||
+ | ||relistemp |bool | |True if this table is a temporary relation. If so, only the creating session can safely access its contents|| | ||
+ | ||relkind |char | |r = ordinary table, i = index, S = sequence, v = view, c = composite type, t = TOAST table|| | ||
+ | ||relnatts |int2 | |Number of user columns in the relation (system columns not counted). There must be this many corresponding entries in pg_attribute. See also pg_attribute.attnum|| | ||
+ | ||relchecks |int2 | |Number of CHECK constraints on the table; see pg_constraint catalog|| | ||
+ | ||relhasoids |bool | |True if we generate an OID for each row of the relation|| | ||
+ | ||relhaspkey |bool | |True if the table has (or once had) a primary key|| | ||
+ | ||relhasrules |bool | |True if table has (or once had) rules; see pg_rewrite catalog|| | ||
+ | ||relhastriggers |bool | |True if table has (or once had) triggers; see pg_trigger catalog|| | ||
+ | ||relhassubclass |bool | |True if table has (or once had) any inheritance children|| | ||
+ | ||relfrozenxid |xid | |All transaction IDs before this one have been replaced with a permanent (" | ||
+ | ||relacl |aclitem[] | |Access privileges; see GRANT and REVOKE for details|Привилегии доступа.| | ||
+ | ||reloptions |text[] | |Access-method-specific options, as " |
📌 Удобный подбор VPS по параметрам доступен на DIEGfinder.com - официальном инструменте проекта DIEG. Это часть единой экосистемы, созданной для того, чтобы помочь быстро найти подходящий VPS/VDS сервер для любых задач хостинга.
📌 Для тестирования скриптов, установщиков VPN и Python-ботов рекомендуем использовать надежные VPS на короткий срок. Подробнее о быстрой аренде VPS для экспериментов - читайте здесь.
💥 Подпишись в Телеграм 💥 и задай вопрос по сайтам и хостингам бесплатно!7 Самых Популярных Статей
- Как запустить скрипты и веб-приложения на Python
- Что такое страны TIER 1,2,3
- 7 способов сравнения файлов по содержимому в Windows или Linux
- Установка и тестирование веб-панели HestiaCP
- Nginx простые примеры конфигурации
- top, htop, atop определение загрузки ОС (Load average, LA)
- Использование rsync в примерах
7 Самых Популярных Обзоров
- Хостинг для Python-скриптов и приложений
- ТОП 4 лучших антидетект браузеров (Бесплатные & Платные)
- Подборка купонов (промокоды) на хостинг, антидетект браузеры
- Обзор THE.Hosting (PQ Hosting): надежный хостинг с профессиональной поддержкой
- Хостинг в России
- Хостинг в Европе
- Обзор браузера Dolphin {anty} для мультиаккаунтинга