Expand description
PostgreSQL identifier types.
This module provides types for PostgreSQL identifier values (table names, schema names, etc.).
Important: These types represent identifier values, not SQL syntax. They do not parse
or produce quoted identifier syntax. For example, a table named my table (with a space)
is represented as the string my table, not as "my table".
Validation rules:
- Cannot be empty
- Maximum length of 63 bytes (NAMEDATALEN - 1)
- Cannot contain NUL bytes
Structs§
- Access
Method - A PostgreSQL access method name.
- Aggregate
- A PostgreSQL aggregate function name.
- Collation
- A PostgreSQL collation name.
- Column
- A PostgreSQL column name.
- Constraint
- A PostgreSQL constraint name.
- Conversion
- A PostgreSQL encoding conversion name.
- Database
- A PostgreSQL database name.
- Domain
- A PostgreSQL domain name.
- Event
Trigger - A PostgreSQL event trigger name.
- Extension
- A PostgreSQL extension name.
- Foreign
Data Wrapper - A PostgreSQL foreign data wrapper name.
- Foreign
Server - A PostgreSQL foreign server name.
- Foreign
Table - A PostgreSQL foreign table name.
- Function
- A PostgreSQL function or procedure name.
- Index
- A PostgreSQL index name.
- Language
- A PostgreSQL procedural language name.
- Materialized
View - A PostgreSQL materialized view name.
- Operator
- A PostgreSQL operator name.
- Operator
Class - A PostgreSQL operator class name.
- Operator
Family - A PostgreSQL operator family name.
- Policy
- A PostgreSQL row-level security policy name.
- Publication
- A PostgreSQL publication name (for logical replication).
- Qualified
Table - A schema-qualified PostgreSQL table name.
- Relation
- A PostgreSQL relation name.
- Role
- A PostgreSQL role name.
- Rule
- A PostgreSQL rule name.
- Schema
- A PostgreSQL schema name.
- Sequence
- A PostgreSQL sequence name.
- Statistics
Object - A PostgreSQL extended statistics object name.
- Subscription
- A PostgreSQL subscription name (for logical replication).
- Table
- A PostgreSQL table name.
- Tablespace
- A PostgreSQL tablespace name.
- Text
Search Configuration - A PostgreSQL text search configuration name.
- Text
Search Dictionary - A PostgreSQL text search dictionary name.
- Trigger
- A PostgreSQL trigger name.
- Type
- A PostgreSQL type name.
- View
- A PostgreSQL view name.
Enums§
- Parse
Error - Error parsing a PostgreSQL identifier.
Constants§
- MAX_
LENGTH - Maximum length of a PostgreSQL identifier in bytes.