Join us on YugabyteDB Community Slack
Star us on
Get Started
Slack
GitHub
Get Started
v2.13 (latest) v2.12 (stable) v2.8 (earlier version) v2.6 (earlier version) v2.4 (earlier version) v2.2 (earlier version) v2.1 (earlier version) v2.0 (earlier version) v1.3 (earlier version)
  • YUGABYTEDB CORE
    • Quick start
      • 1. Install YugabyteDB
      • 2. Create a local cluster
      • 3. Explore distributed SQL
      • 4. Build an application
        • Java
        • Node.js
        • Go
        • Python
        • Ruby
        • C#
        • PHP
        • C++
        • C
        • Scala
    • Explore
      • SQL features
        • Schemas and Tables
        • Data Types
        • Data Manipulation
        • Queries and Joins
        • Expressions and Operators
        • Stored Procedures
        • Triggers
        • Advanced features
          • Cursors
          • Table Partitioning
          • Views
          • Savepoints
          • Collations
          • Extensions
        • Going beyond SQL
          • Follower reads
          • Tablespaces
      • Fault tolerance
      • Horizontal scalability
        • Scaling Transactions
        • Sharding Data
      • Transactions
        • Distributed Transactions
        • Isolation Levels
        • Explicit Locking
      • Indexes and Constraints
        • Overview
        • Unique Indexes
        • Partial Indexes
        • Expression Indexes
        • Generalized Inverted Indexes
        • Primary Key
        • Foreign Key
        • Other Constraints
      • JSON support
      • Multi-region deployments
        • Sync replication (3+ regions)
        • Async Replication (2+ regions)
        • Row-Level Geo-Partitioning
        • Read replicas
      • Query tuning
        • Introduction
        • Get query statistics using pg_stat_statements
        • Viewing live queries with pg_stat_activity
        • Analyzing queries with EXPLAIN
        • Optimizing YSQL queries using pg_hint_plan
      • Cluster management
        • Point-in-time recovery
      • Security
      • Observability
        • Prometheus Integration
        • Grafana Dashboard
    • Develop
      • Learn app development
        • 1. SQL vs NoSQL
        • 2. Data modeling
        • 3. Data types
        • 4. ACID transactions
        • 5. Aggregations
        • 6. Batch operations
        • 7. Date and time
        • 8. Strings and text
        • 9. TTL for data expiration
      • Real-world examples
        • E-Commerce app
        • IoT fleet management
      • Explore sample apps
      • Best practices
      • Cloud-native development
        • Codespaces
        • Gitpod
    • Migrate
      • Migration process overview
      • Migrate from PostgreSQL
        • Convert a PostgreSQL schema
        • Migrate a PostgreSQL application
        • Export PostgreSQL data
        • Prepare a cluster
        • Import PostgreSQL data
        • Verify Migration
    • Deploy
      • Deployment checklist
      • Manual deployment
        • 1. System configuration
        • 2. Install software
        • 3. Start YB-Masters
        • 4. Start YB-TServers
        • 5. Verify deployment
      • Kubernetes
        • Single-zone
          • Open Source
          • Amazon EKS
          • Google Kubernetes Engine
          • Azure Kubernetes Service
        • Multi-zone
          • Amazon EKS
          • Google Kubernetes Engine
        • Multi-cluster
          • Google Kubernetes Engine
        • Best practices
        • Connect Clients
      • Docker
      • Public clouds
        • Amazon Web Services
        • Google Cloud Platform
        • Microsoft Azure
      • Multi-DC deployments
        • Three+ data center (3DC)
        • Asynchronous Replication
        • Read replica clusters
    • Benchmark
      • TPC-C
      • sysbench
      • YCSB
      • Key-value workload
      • Large datasets
      • Scalability
        • Scaling queries
      • Resilience
        • Jepsen testing
      • Performance Troubleshooting
    • Secure
      • Security checklist
      • Enable Authentication
        • Enable User Authentication
        • Configure ysql_hba_conf_csv
      • Authentication Methods
        • Password Authentication
        • LDAP Authentication
        • Host-Based Authentication
        • Trust Authentication
      • Role-Based Access Control
        • Overview
        • Manage Users and Roles
        • Grant Privileges
        • Row-Level Security (RLS)
        • Column-Level Security
      • Encryption in Transit
        • Create server certificates
        • Enable server-to-server encryption
        • Enable client-to-server encryption
        • Connect to Clusters
        • TLS and authentication
      • Encryption at rest
      • Column-level encryption
      • Audit Logging
        • Configure Audit Logging
        • Session-Level Audit Logging
        • Object-Level Audit Logging
      • Vulnerability disclosure policy
    • Manage
      • Back up and restore
        • Back up data
        • Restore data
        • Point-in-time recovery
        • Snapshot and restore data
      • Migrate data
        • Bulk import
        • Bulk export
      • Change cluster configuration
      • Diagnostics reporting
      • Upgrade a deployment
      • Grow cluster
    • Troubleshoot
      • Troubleshooting
      • Cluster level issues
        • YCQL connection issues
        • YEDIS connection Issues
        • Recover tserver/master
        • Replace a failed YB-TServer
        • Replace a failed YB-Master
        • Manual remote bootstrap when a majority of peers fail
      • Node level issues
        • Check servers
        • Inspect logs
        • System statistics
        • Disk failure
        • Common error messages
    • Contribute
      • Core database
        • Contribution checklist
        • Build the source
        • Configure a CLion project
        • Run the tests
        • Coding style
  • YUGABYTE PLATFORM
    • Overview
      • Install
      • Configure
    • Install Yugabyte Platform
      • Prerequisites
      • Prepare the environment
      • Install software
      • Prepare nodes (on-prem)
      • Uninstall software
    • Configure Yugabyte Platform
      • Create admin user
      • Configure the cloud provider
      • Configure the backup target
      • Configure alerts
    • Create deployments
      • Multi-zone universe
      • Multi-region universe
      • Multi-cloud universe
      • Read replica cluster
      • Asynchronous replication
    • Manage deployments
      • Start and stop processes
      • Add a node
      • Eliminate an unresponsive node
      • Enable high availability
      • Edit configuration flags
      • Edit a universe
      • Delete a universe
      • Configure instance tags
      • Upgrade YugabyteDB software
      • Migrate to Helm 3
    • Back up universes
      • Configure backup storage
      • Back up universe data
      • Restore universe data
      • Schedule data backups
    • Security
      • Security checklist
      • Customize ports
      • LDAP authentication
      • Authorization platform
      • Create a KMS configuration
      • Enable encryption at rest
      • Enable encryption in transit (TLS)
      • Network security
    • Alerts and monitoring
      • Alerts
      • Live Queries dashboard
      • Slow Queries dashboard
    • Troubleshoot
      • Install and upgrade issues
      • Universe issues
    • Administer Yugabyte Platform
      • Back Up Yugabyte Platform
      • Authenticate with LDAP
    • Upgrade Yugabyte Platform
      • Upgrade using Replicated
  • YUGABYTE CLOUD
    • Overview
    • Quick start
      • Create a free cluster
      • Connect to the cluster
      • Create a database
      • Explore distributed SQL
      • Build an application
        • Before you begin
        • Java
        • Go
        • Python
        • Node.js
        • C
        • C++
        • C#
        • Ruby
        • Rust
        • PHP
    • Deploy clusters
      • Planning a cluster
      • Create a free cluster
      • Create a standard cluster
      • VPC network
        • Overview
        • Set up a VPC network
        • VPCs
        • Peering Connections
    • Secure clusters
      • IP allow lists
      • Database authorization
      • Add database users
      • Encryption in transit
      • Audit cloud activity
    • Connect to clusters
      • Cloud Shell
      • Client shell
      • Connect applications
    • Alerts and monitoring
      • Alerts
      • Performance metrics
      • Live queries
      • Slow YSQL queries
      • Cluster activity
    • Manage clusters
      • Backup and restore
      • Scale and configure clusters
      • Create extensions
    • Administer Yugabyte Cloud
      • Manage cloud users
      • Manage billing
      • Cluster costs
    • Example applications
      • Connect a Spring application
      • Connect a YCQL Java application
      • Hasura Cloud
      • Deploy a GraphQL application
    • Security architecture
      • Security architecture
      • Shared responsibility model
    • Troubleshoot
    • Yugabyte Cloud FAQ
    • What's new
  • INTEGRATIONS
    • Apache Kafka
    • Apache Spark
    • JanusGraph
    • KairosDB
    • Presto
    • Metabase
    • WSO2 Identity Server
    • YSQL Loader
    • Yugabyte JDBC Driver
    • Prisma
    • Hasura
      • Application Development
      • Benchmarking
    • Spring Framework
      • Spring Data YugabyteDB
      • Spring Data Cassandra
    • Flyway
    • GORM
    • Liquibase
    • Sequelize
    • SQLAlchemy
    • Entity Framework
    • Django REST framework
  • REFERENCE
    • Architecture
      • Design goals
      • Key concepts
        • Universe
        • YB-TServer Service
        • YB-Master Service
      • Core functions
        • Universe creation
        • Table creation
        • Write IO path
        • Read IO path
        • High availability
      • Layered architecture
      • Query layer
        • Overview
      • DocDB transactions layer
        • Transactions overview
        • Transaction isolation levels
        • Explicit locking
        • Read Committed
        • Single-row transactions
        • Distributed transactions
        • Transactional IO path
      • DocDB sharding layer
        • Hash & range sharding
        • Tablet splitting
        • Colocated tables
      • DocDB replication layer
        • Replication
        • xCluster replication
        • Read replicas
        • Change data capture (CDC)
      • DocDB storage layer
        • Persistence
        • Performance
    • APIs
      • YSQL
        • The SQL language
          • SQL statements
            • ABORT
            • ALTER DATABASE
            • ALTER DEFAULT PRIVILEGES
            • ALTER DOMAIN
            • ALTER GROUP
            • ALTER POLICY
            • ALTER ROLE
            • ALTER SEQUENCE
            • ALTER TABLE
            • ALTER USER
            • ANALYZE
            • BEGIN
            • CALL
            • COMMENT
            • COMMIT
            • COPY
            • CREATE AGGREGATE
            • CREATE CAST
            • CREATE DATABASE
            • CREATE DOMAIN
            • CREATE EXTENSION
            • CREATE FUNCTION
            • CREATE GROUP
            • CREATE INDEX
            • CREATE MATERIALIZED VIEW
            • CREATE OPERATOR
            • CREATE OPERATOR CLASS
            • CREATE POLICY
            • CREATE PROCEDURE
            • CREATE ROLE
            • CREATE RULE
            • CREATE SCHEMA
            • CREATE SEQUENCE
            • CREATE TABLE
            • CREATE TABLE AS
            • CREATE TRIGGER
            • CREATE TYPE
            • CREATE USER
            • CREATE VIEW
            • DEALLOCATE
            • DELETE
            • DO
            • DROP AGGREGATE
            • DROP CAST
            • DROP DATABASE
            • DROP DOMAIN
            • DROP EXTENSION
            • DROP FUNCTION
            • DROP GROUP
            • DROP MATERIALIZED VIEW
            • DROP OPERATOR
            • DROP OPERATOR CLASS
            • DROP OWNED
            • DROP POLICY
            • DROP PROCEDURE
            • DROP ROLE
            • DROP RULE
            • DROP SEQUENCE
            • DROP TABLE
            • DROP TRIGGER
            • DROP TYPE
            • DROP USER
            • END
            • EXECUTE
            • EXPLAIN
            • GRANT
            • INSERT
            • LOCK
            • PREPARE
            • REASSIGN OWNED
            • REFRESH MATERIALIZED VIEW
            • RELEASE SAVEPOINT
            • RESET
            • REVOKE
            • ROLLBACK
            • ROLLBACK TO SAVEPOINT
            • SAVEPOINT
            • SELECT
            • SET
            • SET CONSTRAINTS
            • SET ROLE
            • SET SESSION AUTHORIZATION
            • SET TRANSACTION
            • SHOW
            • SHOW TRANSACTION
            • TRUNCATE
            • UPDATE
            • VALUES
          • WITH clause
            • WITH clause—SQL syntax and semantics
            • recursive CTE
            • case study—traversing an employee hierarchy
            • traversing general graphs
              • graph representation
              • common code
              • undirected cyclic graph
              • directed cyclic graph
              • directed acyclic graph
              • rooted tree
              • Unique containing paths
              • Stress testing find_paths()
            • case study—Bacon Numbers from IMDb
              • Bacon numbers for synthetic data
              • Bacon numbers for IMDb data
        • Data types
          • Array
            • array[] constructor
            • Literals
              • Text typecasting and literals
              • Array of primitive values
              • Row
              • Array of rows
            • FOREACH loop (PL/pgSQL)
            • array of DOMAINs
            • Functions and operators
              • ANY and ALL
              • Array comparison
              • Array slice operator
              • Array concatenation
              • Array properties
              • array_agg(), unnest(), generate_subscripts()
              • array_fill()
              • array_position(), array_positions()
              • array_remove()
              • array_replace() / set value
              • array_to_string()
              • string_to_array()
          • Binary
          • Boolean
          • Character
          • Date and time
            • Conceptual background
            • Timezones and UTC offsets
              • Catalog views
              • Extended_timezone_names
                • Unrestricted full projection
                • Real timezones with DST
                • Real timezones no DST
                • Synthetic timezones no DST
              • Offset/timezone-sensitive operations
                • Timestamptz to/from timestamp conversion
                • Pure 'day' interval arithmetic
              • Four ways to specify offset
                • Name-resolution rules
                  • 1 case-insensitive resolution
                  • 2 ~names.abbrev never searched
                  • 3 'set timezone' string not resolved in ~abbrevs.abbrev
                  • 4 ~abbrevs.abbrev before ~names.name
                  • Helper functions
              • Syntax contexts for offset
              • Recommended practice
            • Typecasting between date-time and text-values
            • Semantics of the date-time data types
              • Date data type
              • Time data type
              • Plain timestamp and timestamptz
              • Interval data type
                • Interval representation
                  • Ad hoc examples
                  • Representation model
                • Interval value limits
                • Declaring intervals
                • Justify() and extract(epoch...)
                • Interval arithmetic
                  • Interval-interval comparison
                  • Interval-interval addition and subtraction
                  • Interval-number multiplication
                  • Moment-moment overloads of "-"
                  • Moment-interval overloads of "+" and "-"
                • Custom interval domains
                • Interval utility functions
            • Typecasting between date-time datatypes
            • Operators
              • Test comparison overloads
              • Test addition overloads
              • Test subtraction overloads
              • Test multiplication overloads
              • Test division overloads
            • General-purpose functions
              • Creating date-time values
              • Manipulating date-time values
              • Current date-time moment
              • Delaying execution
              • Miscellaneous
                • Function age()
                • Function extract() | date_part()
                • Implementations that model the overlaps operator
            • Formatting functions
            • Case study—SQL stopwatch
            • Download & install the date-time utilities
            • ToC
          • JSON
            • JSON literals
            • Primitive and compound data types
            • Code example conventions
            • Indexes and check constraints
            • Functions & operators
              • ::jsonb, ::json, ::text (typecast)
              • ->, ->>, #>, #>> (JSON subvalues)
              • - and #- (remove)
              • || (concatenation)
              • = (equality)
              • @> and <@ (containment)
              • ? and ?| and ?& (key or value existence)
              • array_to_json()
              • jsonb_agg()
              • jsonb_array_elements()
              • jsonb_array_elements_text()
              • jsonb_array_length()
              • jsonb_build_object()
              • jsonb_build_array()
              • jsonb_each()
              • jsonb_each_text()
              • jsonb_extract_path()
              • jsonb_extract_path_text() and json_extract_path_text()
              • jsonb_object()
              • jsonb_object_agg()
              • jsonb_object_keys()
              • jsonb_populate_record()
              • jsonb_populate_recordset()
              • jsonb_pretty()
              • jsonb_set() and jsonb_insert()
              • jsonb_strip_nulls()
              • jsonb_to_record()
              • jsonb_to_recordset()
              • jsonb_typeof()
              • row_to_json()
              • to_jsonb()
          • Money
          • Numeric
          • Range
          • Serial
          • UUID
        • Functions and operators
          • Aggregate functions
            • Informal functionality overview
            • Invocation syntax and semantics
            • grouping sets, rollup, cube
            • Per function signature and purpose
              • avg(), count(), max(), min(), sum()
              • array_agg(), string_agg(), jsonb_agg(), jsonb_object_agg()
              • bit_and(), bit_or(), bool_and(), bool_or()
              • variance(), var_pop(), var_samp(), stddev(), stddev_pop(), stddev_samp()
              • linear regression
                • covar_pop(), covar_samp(), corr()
                • regr_%()
              • mode(), percentile_disc(), percentile_cont()
              • rank(), dense_rank(), percent_rank(), cume_dist()
            • case study—percentile_cont() and the "68–95–99.7" rule
            • case study—linear regression on COVID data
              • Download the COVIDcast data
              • Ingest the COVIDcast data
                • Inspect the COVIDcast data
                • Copy the .csv files to staging tables
                • Check staged data conforms to the rules
                • Join the staged data into a single table
                • SQL scripts
                  • Create cr_staging_tables()
                  • Create cr_copy_from_scripts()
                  • Create assert_assumptions_ok()
                  • Create xform_to_covidcast_fb_survey_results()
                  • ingest-the-data.sql
              • Analyze the COVIDcast data
                • symptoms vs mask-wearing by day
                • Data for scatter-plot for 21-Oct-2020
                • Scatter-plot for 21-Oct-2020
                • SQL scripts
                  • analysis-queries.sql
                  • synthetic-data.sql
          • currval()
          • lastval()
          • nextval()
          • Window functions
            • Informal functionality overview
            • Invocation syntax and semantics
            • Per function signature and purpose
              • row_number(), rank() and dense_rank()
              • percent_rank(), cume_dist() and ntile()
              • first_value(), nth_value(), last_value()
              • lag(), lead()
              • Tables for the code examples
                • table t1
                • table t2
                • table t3
                • table t4
            • case study—analyzing a normal distribution
              • Bucket allocation scheme
              • do_clean_start.sql
              • cr_show_t4.sql
              • cr_dp_views.sql
              • cr_int_views.sql
              • cr_pr_cd_equality_report.sql
              • cr_bucket_using_width_bucket.sql
              • cr_bucket_dedicated_code.sql
              • do_assert_bucket_ok
              • cr_histogram.sql
              • cr_do_ntile.sql
              • cr_do_percent_rank.sql
              • cr_do_cume_dist.sql
              • do_populate_results.sql
              • do_report_results.sql
              • do_compare_dp_results.sql
              • do_demo.sql
              • Reports
                • Histogram report
                • dp-results
                • compare-dp-results
                • int-results
          • yb_hash_code()
        • Extensions
        • Keywords
        • Reserved names
      • YCQL
        • ALTER KEYSPACE
        • ALTER ROLE
        • ALTER TABLE
        • CREATE INDEX
        • CREATE KEYSPACE
        • CREATE ROLE
        • CREATE TABLE
        • CREATE TYPE
        • DROP INDEX
        • DROP KEYSPACE
        • DROP ROLE
        • DROP TABLE
        • DROP TYPE
        • GRANT PERMISSION
        • GRANT ROLE
        • REVOKE PERMISSION
        • REVOKE ROLE
        • USE
        • INSERT
        • SELECT
        • EXPLAIN
        • UPDATE
        • DELETE
        • TRANSACTION
        • TRUNCATE
        • Simple expressions
        • Subscripted expressions
        • Function call
        • Operators
        • BLOB
        • BOOLEAN
        • Collection
        • FROZEN
        • INET
        • Integer and counter
        • Non-integer
        • TEXT
        • DATE, TIME, and TIMESTAMP
        • UUID and TIMEUUID
        • JSONB
        • Date and time
        • BATCH
    • CLIs
      • yb-ctl
      • yb-docker-ctl
      • ysqlsh
      • ycqlsh
      • yb-admin
      • yb-ts-cli
      • ysql_dump
      • ysql_dumpall
    • Configuration
      • yb-tserver
      • yb-master
      • yugabyted
      • Default ports
    • Drivers
      • Client drivers for YSQL
      • Client drivers for YCQL
    • Connectors
      • Kafka Connect YugabyteDB
    • Third party tools
      • Arctype
      • DBeaver
      • DbSchema
      • pgAdmin
      • SQL Workbench/J
      • TablePlus
      • Visual Studio Code
    • Sample datasets
      • Chinook
      • Northwind
      • PgExercises
      • SportsDB
      • Retail Analytics
  • RELEASES
    • Releases overview
      • v2.13 series (latest)
      • v2.12 series (stable)
      • v2.11 series
      • v2.9 series
      • v2.8 series
      • v2.7 series
      • v2.6 series
      • v2.5 series
      • v2.4 series
      • v2.3 series
      • v2.2 series
      • v2.1 series
      • v2.0 series
      • v1.3 series
      • v1.2 series
    • Release versioning
  • FAQ
    • Comparisons
      • Amazon Aurora
      • Google Cloud Spanner
      • CockroachDB
      • TiDB
      • Vitess
      • MongoDB
      • FoundationDB
      • Amazon DynamoDB
      • Azure Cosmos DB
      • Apache Cassandra
      • PostgreSQL
      • Redis in-memory store
      • Apache HBase
    • General FAQ
    • Operations FAQ
    • API compatibility FAQ
    • Yugabyte Platform FAQ
  • MISC
    • YEDIS
      • Quick start
      • Develop
        • Build an application
        • C#
        • C++
        • Go
        • Java
        • NodeJS
        • Python
      • API reference
        • APPEND
        • AUTH
        • CONFIG
        • CREATEDB
        • DELETEDB
        • LISTDB
        • SELECT
        • DEL
        • ECHO
        • EXISTS
        • EXPIRE
        • EXPIREAT
        • FLUSHALL
        • FLUSHDB
        • GET
        • GETRANGE
        • GETSET
        • HDEL
        • HEXISTS
        • HGET
        • HGETALL
        • HINCRBY
        • HKEYS
        • HLEN
        • HMGET
        • HMSET
        • HSET
        • HSTRLEN
        • HVALS
        • INCR
        • INCRBY
        • KEYS
        • MONITOR
        • PEXPIRE
        • PEXPIREAT
        • PTTL
        • ROLE
        • SADD
        • SCARD
        • RENAME
        • SET
        • SETEX
        • PSETEX
        • SETRANGE
        • SISMEMBER
        • SMEMBERS
        • SREM
        • STRLEN
        • ZRANGE
        • TSADD
        • TSCARD
        • TSGET
        • TSLASTN
        • TSRANGEBYTIME
        • TSREM
        • TSREVRANGEBYTIME
        • TTL
        • ZADD
        • ZCARD
        • ZRANGEBYSCORE
        • ZREM
        • ZREVRANGE
        • ZSCORE
        • PUBSUB
        • PUBLISH
        • SUBSCRIBE
        • UNSUBSCRIBE
        • PSUBSCRIBE
        • PUNSUBSCRIBE
    • Legal
      • Third party software
> APIs > YSQL >

Keywords

Report a doc issue Suggest new content
Keywords Usage Exceptions
ABORT unreserved No exception
ABSOLUTE unreserved No exception
ACCESS unreserved No exception
ACTION unreserved No exception
ADD unreserved No exception
ADMIN unreserved No exception
AFTER unreserved No exception
AGGREGATE unreserved No exception
ALL reserved No exception
ALSO unreserved No exception
ALTER unreserved No exception
ALWAYS unreserved No exception
ANALYSE reserved No exception
ANALYZE reserved No exception
AND reserved No exception
ANY reserved No exception
ARRAY reserved No exception
AS reserved No exception
ASC reserved No exception
ASSERTION unreserved No exception
ASSIGNMENT unreserved No exception
ASYMMETRIC reserved No exception
AT unreserved No exception
ATTACH unreserved No exception
ATTRIBUTE unreserved No exception
AUTHORIZATION reserved Can be used for function, type, or alias names
BACKWARD unreserved No exception
BEFORE unreserved No exception
BEGIN unreserved No exception
BETWEEN unreserved Not allowed for function or type names
BIGINT unreserved Not allowed for function or type names
BINARY reserved Can be used for function, type, or alias names
BIT unreserved Not allowed for function or type names
BOOLEAN unreserved Not allowed for function or type names
BOTH reserved No exception
BY unreserved No exception
CACHE unreserved No exception
CALLED unreserved No exception
CASCADE unreserved No exception
CASCADED unreserved No exception
CASE reserved No exception
CAST reserved No exception
CATALOG unreserved No exception
CHAIN unreserved No exception
CHAR unreserved Not allowed for function or type names
CHARACTER unreserved Not allowed for function or type names
CHARACTERISTICS unreserved No exception
CHECK reserved No exception
CHECKPOINT unreserved No exception
CLASS unreserved No exception
CLOSE unreserved No exception
CLUSTER unreserved No exception
COALESCE unreserved Not allowed for function or type names
COLLATE reserved No exception
COLLATION reserved Can be used for function, type, or alias names
COLUMN reserved No exception
COLUMNS unreserved No exception
COMMENT unreserved No exception
COMMENTS unreserved No exception
COMMIT unreserved No exception
COMMITTED unreserved No exception
CONCURRENTLY reserved Can be used for function, type, or alias names
CONFIGURATION unreserved No exception
CONFLICT unreserved No exception
CONNECTION unreserved No exception
CONSTRAINT reserved No exception
CONSTRAINTS unreserved No exception
CONTENT unreserved No exception
CONTINUE unreserved No exception
CONVERSION unreserved No exception
COPY unreserved No exception
COST unreserved No exception
CREATE reserved No exception
CROSS reserved Can be used for function, type, or alias names
CSV unreserved No exception
CUBE unreserved No exception
CURRENT unreserved No exception
CURRENT_CATALOG reserved No exception
CURRENT_DATE reserved No exception
CURRENT_ROLE reserved No exception
CURRENT_SCHEMA reserved Can be used for function, type, or alias names
CURRENT_TIME reserved No exception
CURRENT_TIMESTAMP reserved No exception
CURRENT_USER reserved No exception
CURSOR unreserved No exception
CYCLE unreserved No exception
DATA unreserved No exception
DATABASE unreserved No exception
DAY unreserved No exception
DEALLOCATE unreserved No exception
DEC unreserved Not allowed for function or type names
DECIMAL unreserved Not allowed for function or type names
DECLARE unreserved No exception
DEFAULT reserved No exception
DEFAULTS unreserved No exception
DEFERRABLE reserved No exception
DEFERRED unreserved No exception
DEFINER unreserved No exception
DELETE unreserved No exception
DELIMITER unreserved No exception
DELIMITERS unreserved No exception
DEPENDS unreserved No exception
DESC reserved No exception
DETACH unreserved No exception
DICTIONARY unreserved No exception
DISABLE unreserved No exception
DISCARD unreserved No exception
DISTINCT reserved No exception
DO reserved No exception
DOCUMENT unreserved No exception
DOMAIN unreserved No exception
DOUBLE unreserved No exception
DROP unreserved No exception
EACH unreserved No exception
ELSE reserved No exception
ENABLE unreserved No exception
ENCODING unreserved No exception
ENCRYPTED unreserved No exception
END reserved No exception
ENUM unreserved No exception
ESCAPE unreserved No exception
EVENT unreserved No exception
EXCEPT reserved No exception
EXCLUDE unreserved No exception
EXCLUDING unreserved No exception
EXCLUSIVE unreserved No exception
EXECUTE unreserved No exception
EXISTS unreserved Not allowed for function or type names
EXPLAIN unreserved No exception
EXTENSION unreserved No exception
EXTERNAL unreserved No exception
EXTRACT unreserved Not allowed for function or type names
FALSE reserved No exception
FAMILY unreserved No exception
FETCH reserved No exception
FILTER unreserved No exception
FIRST unreserved No exception
FLOAT unreserved Not allowed for function or type names
FOLLOWING unreserved No exception
FOR reserved No exception
FORCE unreserved No exception
FOREIGN reserved No exception
FORWARD unreserved No exception
FREEZE reserved Can be used for function, type, or alias names
FROM reserved No exception
FULL reserved Can be used for function, type, or alias names
FUNCTION unreserved No exception
FUNCTIONS unreserved No exception
GENERATED unreserved No exception
GLOBAL unreserved No exception
GRANT reserved No exception
GRANTED unreserved No exception
GREATEST unreserved Not allowed for function or type names
GROUP reserved No exception
GROUPING unreserved Not allowed for function or type names
HANDLER unreserved No exception
HAVING reserved No exception
HEADER unreserved No exception
HOLD unreserved No exception
HOUR unreserved No exception
IDENTITY unreserved No exception
IF unreserved No exception
ILIKE reserved Can be used for function, type, or alias names
IMMEDIATE unreserved No exception
IMMUTABLE unreserved No exception
IMPLICIT unreserved No exception
IMPORT unreserved No exception
IN reserved No exception
INCLUDING unreserved No exception
INCREMENT unreserved No exception
INDEX unreserved No exception
INDEXES unreserved No exception
INHERIT unreserved No exception
INHERITS unreserved No exception
INITIALLY reserved No exception
INLINE unreserved No exception
INNER reserved Can be used for function, type, or alias names
INOUT unreserved Not allowed for function or type names
INPUT unreserved No exception
INSENSITIVE unreserved No exception
INSERT unreserved No exception
INSTEAD unreserved No exception
INT unreserved Not allowed for function or type names
INTEGER unreserved Not allowed for function or type names
INTERSECT reserved No exception
INTERVAL unreserved Not allowed for function or type names
INTO reserved No exception
INVOKER unreserved No exception
IS reserved Can be used for function, type, or alias names
ISNULL reserved Can be used for function, type, or alias names
ISOLATION unreserved No exception
JOIN reserved Can be used for function, type, or alias names
KEY unreserved No exception
LABEL unreserved No exception
LANGUAGE unreserved No exception
LARGE unreserved No exception
LAST unreserved No exception
LATERAL reserved No exception
LEADING reserved No exception
LEAKPROOF unreserved No exception
LEAST unreserved Not allowed for function or type names
LEFT reserved Can be used for function, type, or alias names
LEVEL unreserved No exception
LIKE reserved Can be used for function, type, or alias names
LIMIT reserved No exception
LISTEN unreserved No exception
LOAD unreserved No exception
LOCAL unreserved No exception
LOCALTIME reserved No exception
LOCALTIMESTAMP reserved No exception
LOCATION unreserved No exception
LOCK unreserved No exception
LOCKED unreserved No exception
LOGGED unreserved No exception
MAPPING unreserved No exception
MATCH unreserved No exception
MATERIALIZED unreserved No exception
MAXVALUE unreserved No exception
METHOD unreserved No exception
MINUTE unreserved No exception
MINVALUE unreserved No exception
MODE unreserved No exception
MONTH unreserved No exception
MOVE unreserved No exception
NAME unreserved No exception
NAMES unreserved No exception
NATIONAL unreserved Not allowed for function or type names
NATURAL reserved Can be used for function, type, or alias names
NCHAR unreserved Not allowed for function or type names
NEW unreserved No exception
NEXT unreserved No exception
NO EXCEPTION unreserved No exception
NONE unreserved Not allowed for function or type names
NOT reserved No exception
NOTHING unreserved No exception
NOTIFY unreserved No exception
NOTNULL reserved Can be used for function, type, or alias names
NOWAIT unreserved No exception
NULL reserved No exception
NULLIF unreserved Not allowed for function or type names
NULLS unreserved No exception
NUMERIC unreserved Not allowed for function or type names
OBJECT unreserved No exception
OF unreserved No exception
OFF unreserved No exception
OFFSET reserved No exception
OIDS unreserved No exception
OLD unreserved No exception
ON reserved No exception
ONLY reserved No exception
OPERATOR unreserved No exception
OPTION unreserved No exception
OPTIONS unreserved No exception
OR reserved No exception
ORDER reserved No exception
ORDINALITY unreserved No exception
OUT unreserved Not allowed for function or type names
OUTER reserved Can be used for function, type, or alias names
OVER unreserved No exception
OVERLAPS reserved Can be used for function, type, or alias names
OVERLAY unreserved Not allowed for function or type names
OVERRIDING unreserved No exception
OWNED unreserved No exception
OWNER unreserved No exception
PARALLEL unreserved No exception
PARSER unreserved No exception
PARTIAL unreserved No exception
PARTITION unreserved No exception
PASSING unreserved No exception
PASSWORD unreserved No exception
PLACING reserved No exception
PLANS unreserved No exception
POLICY unreserved No exception
POSITION unreserved Not allowed for function or type names
PRECEDING unreserved No exception
PRECISION unreserved Not allowed for function or type names
PREPARE unreserved No exception
PREPARED unreserved No exception
PRESERVE unreserved No exception
PRIMARY reserved No exception
PRIOR unreserved No exception
PRIVILEGES unreserved No exception
PROCEDURAL unreserved No exception
PROCEDURE unreserved No exception
PROGRAM unreserved No exception
PUBLICATION unreserved No exception
QUOTE unreserved No exception
RANGE unreserved No exception
READ unreserved No exception
REAL unreserved Not allowed for function or type names
REASSIGN unreserved No exception
RECHECK unreserved No exception
RECURSIVE unreserved No exception
REF unreserved No exception
REFERENCES reserved No exception
REFERENCING unreserved No exception
REFRESH unreserved No exception
REINDEX unreserved No exception
RELATIVE unreserved No exception
RELEASE unreserved No exception
RENAME unreserved No exception
REPEATABLE unreserved No exception
REPLACE unreserved No exception
REPLICA unreserved No exception
RESET unreserved No exception
RESTART unreserved No exception
RESTRICT unreserved No exception
RETURNING reserved No exception
RETURNS unreserved No exception
REVOKE unreserved No exception
RIGHT reserved Can be used for function, type, or alias names
ROLE unreserved No exception
ROLLBACK unreserved No exception
ROLLUP unreserved No exception
ROW unreserved Not allowed for function or type names
ROWS unreserved No exception
RULE unreserved No exception
SAVEPOINT unreserved No exception
SCHEMA unreserved No exception
SCHEMAS unreserved No exception
SCROLL unreserved No exception
SEARCH unreserved No exception
SECOND unreserved No exception
SECURITY unreserved No exception
SELECT reserved No exception
SEQUENCE unreserved No exception
SEQUENCES unreserved No exception
SERIALIZABLE unreserved No exception
SERVER unreserved No exception
SESSION unreserved No exception
SESSION_USER reserved No exception
SET unreserved No exception
SETOF unreserved Not allowed for function or type names
SETS unreserved No exception
SHARE unreserved No exception
SHOW unreserved No exception
SIMILAR reserved Can be used for function, type, or alias names
SIMPLE unreserved No exception
SKIP unreserved No exception
SMALLINT unreserved Not allowed for function or type names
SNAPSHOT unreserved No exception
SOME reserved No exception
SQL unreserved No exception
STABLE unreserved No exception
STANDALONE unreserved No exception
START unreserved No exception
STATEMENT unreserved No exception
STATISTICS unreserved No exception
STDIN unreserved No exception
STDOUT unreserved No exception
STORAGE unreserved No exception
STRICT unreserved No exception
STRIP unreserved No exception
SUBSCRIPTION unreserved No exception
SUBSTRING unreserved Not allowed for function or type names
SYMMETRIC reserved No exception
SYSID unreserved No exception
SYSTEM unreserved No exception
TABLE reserved No exception
TABLES unreserved No exception
TABLESAMPLE reserved Can be used for function, type, or alias names
TABLESPACE unreserved No exception
TEMP unreserved No exception
TEMPLATE unreserved No exception
TEMPORARY unreserved No exception
TEXT unreserved No exception
THEN reserved No exception
TIME unreserved Not allowed for function or type names
TIMESTAMP unreserved Not allowed for function or type names
TO reserved No exception
TRAILING reserved No exception
TRANSACTION unreserved No exception
TRANSFORM unreserved No exception
TREAT unreserved Not allowed for function or type names
TRIGGER unreserved No exception
TRIM unreserved Not allowed for function or type names
TRUE reserved No exception
TRUNCATE unreserved No exception
TRUSTED unreserved No exception
TYPE unreserved No exception
TYPES unreserved No exception
UNBOUNDED unreserved No exception
UNCOMMITTED unreserved No exception
UNENCRYPTED unreserved No exception
UNION reserved No exception
UNIQUE reserved No exception
UNKNOWN unreserved No exception
UNLISTEN unreserved No exception
UNLOGGED unreserved No exception
UNTIL unreserved No exception
UPDATE unreserved No exception
USER reserved No exception
USING reserved No exception
VACUUM unreserved No exception
VALID unreserved No exception
VALIDATE unreserved No exception
VALIDATOR unreserved No exception
VALUE unreserved No exception
VALUES unreserved Not allowed for function or type names
VARCHAR unreserved Not allowed for function or type names
VARIADIC reserved No exception
VARYING unreserved No exception
VERBOSE reserved Can be used for function, type, or alias names
VERSION unreserved No exception
VIEW unreserved No exception
VIEWS unreserved No exception
VOLATILE unreserved No exception
WHEN reserved No exception
WHERE reserved No exception
WHITESPACE unreserved No exception
WINDOW reserved No exception
WITH reserved No exception
WITHIN unreserved No exception
WITHOUT unreserved No exception
WORK unreserved No exception
WRAPPER unreserved No exception
WRITE unreserved No exception
XML unreserved No exception
XMLATTRIBUTES unreserved Not allowed for function or type names
XMLCONCAT unreserved Not allowed for function or type names
XMLELEMENT unreserved Not allowed for function or type names
XMLEXISTS unreserved Not allowed for function or type names
XMLFOREST unreserved Not allowed for function or type names
XMLNAMESPACES unreserved Not allowed for function or type names
XMLPARSE unreserved Not allowed for function or type names
XMLPI unreserved Not allowed for function or type names
XMLROOT unreserved Not allowed for function or type names
XMLSERIALIZE unreserved Not allowed for function or type names
XMLTABLE unreserved Not allowed for function or type names
YEAR unreserved No exception
YES unreserved No exception
ZONE unreserved No exception
Ask our community
  • Slack
  • Github
  • Forum
  • StackOverflow
Yugabyte
Contact Us
Copyright © 2017-2022 Yugabyte, Inc. All rights reserved.