PostgreSQL源码

/*------------------------------------------------------------------------- * * keywords.c * lexical token lookup for reserved words in PostgreSQL * * Portions Copyright (c) 1996-2006, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * * * IDENTIFICATION * $PostgreSQL: pgsql/src/backend/parser/keywords.c,v 1.177 2006/10/07 21:51:02 petere Exp $ * *------------------------------------------------------------------------- */ /////////////////////////////////////////////////////////////////////////// // // pgAdmin note: This file is based on src/backend/parser/keywords.c from // PostgreSQL. It should be periodically updated to include // new keywords. The ScanKeywords array and the definition // of ScanKeywordLookup are all that are required here - when // updating, ensure that no unecessary includes are added. // // This file is under the BSD licence, per PostgreSQL. /////////////////////////////////////////////////////////////////////////// #include "postgres.h" #include "parser/keywords.h" /* * List of (keyword-name, keyword-token-value) pairs. * * !!WARNING!!: This list must be sorted, because binary * search is used to locate entries. */ static const ScanKeyword ScanKeywords[] = { /* name, value, category */ {"abort", ABORT_P, UNRESERVED_KEYWORD}, {"absolute", ABSOLUTE_P, UNRESERVED_KEYWORD}, {"access", ACCESS, UNRESERVED_KEYWORD}, {"action", ACTION, UNRESERVED_KEYWORD}, {"add", ADD_P, UNRESERVED_KEYWORD}, {"admin", ADMIN, UNRESERVED_KEYWORD}, {"after", AFTER, UNRESERVED_KEYWORD}, {"aggregate", AGGREGATE, UNRESERVED_KEYWORD}, {"all", ALL, RESERVED_KEYWORD}, {"also", ALSO, UNRESERVED_KEYWORD}, {"alter", ALTER, UNRESERVED_KEYWORD}, {"always", ALWAYS, UNRESERVED_KEYWORD}, {"analyse", ANALYSE, RESERVED_KEYWORD}, /* British spelling */ {"analyze", ANALYZE, RESERVED_KEYWORD}, {"and", AND, RESERVED_KEYWORD}, {"any", ANY, RESERVED_KEYWORD}, {"array", ARRAY, RESERVED_KEYWORD}, {"as", AS, RESERVED_KEYWORD}, {"asc", ASC, RESERVED_KEYWORD}, {"assertion", ASSERTION, UNRESERVED_KEYWORD}, {"assignment", ASSIGNMENT, UNRESERVED_KEYWORD}, {"asymmetric", ASYMMETRIC, RESERVED_KEYWORD}, {"at", AT, UNRESERVED_KEYWORD}, {"authorization", AUTHORIZATION, TYPE_FUNC_NAME_KEYWORD}, {"autovacuum_enabled", AUTOVACUUM_E, UNRESERVED_KEYWORD}, {"autovacuum_vacuum_threshold", AUTOVACUUM_V_TH, UNRESERVED_KEYWORD}, {"autovacuum_analyze_threshold", AUTOVACUUM_A_TH, UNRESERVED_KEYWORD}, {"autovacuum_vacuum_scale_factor", AUTOVACUUM_V_SC_F, UNRESERVED_KEYWORD}, {"autovacuum_analyze_scale_factor", AUTOVACUUM_A_SC_F, UNRESERVED_KEYWORD}, {"autovacuum_vacuum_cost_delay", AUTOVACUUM_V_COST_D, UNRESERVED_KEYWORD}, {"autovacuum_vacuum_cost_limit", AUTOVACUUM_V_COST_L, UNRESERVED_KEYWORD}, {"autovacuum_freeze_min_age", AUTOVACUUM_F_MIN_AGE, UNRESERVED_KEYWORD}, {"autovacuum_freeze_max_age", AUTOVACUUM_F_MAX_AGE, UNRESERVED_KEYWORD}, {"autovacuum_freeze_table_age", AUTOVACUUM_F_TBL_AGE, UNRESERVED_KEYWORD}, {"backward", BACKWARD, UNRESERVED_KEYWORD}, {"before", BEFORE, UNRESERVED_KEYWORD}, {"begin", BEGIN_P, UNRESERVED_KEYWORD}, {"between", BETWEEN, TYPE_FUNC_NAME_KEYWORD}, {"bigint", BIGINT, COL_NAME_KEYWORD}, {"binary", BINARY, TYPE_FUNC_NAME_KEYWORD}, {"bit", BIT, COL_NAME_KEYWORD}, {"boolean", BOOLEAN_P, COL_NAME_KEYWORD}, {"both", BOTH, RESERVED_KEYWORD}, {"by", BY, UNRESERVED_KEYWORD}, {"cache", CACHE, UNRESERVED_KEYWORD}, {"called", CALLED, UNRESERVED_KEYWORD}, {"cascade", CASCADE, UNRESERVED_KEYWORD}, {"cascaded", CASCADED, UNRESERVED_KEYWORD}, {"case", CASE, RESERVED_KEYWORD}, {"cast", CAST, RESERVED_KEYWORD}, {"chain", CHAIN, UNRESERVED_KEYWORD}, {"char", CHAR_P, COL_NAME_KEYWORD}, {"character", CHARACTER, COL_NAME_KEYWORD}, {"characteristics", CHARACTERISTICS, UNRESERVED_KEYWORD}, {"check", CHECK, RESERVED_KEYWORD}, {"checkpoint", CHECKPOINT, UNRESERVED_KEYWORD}, {"class", CLASS, UNRESERVED_KEYWORD}, {"close", CLOSE, UNRESERVED_KEYWORD}, {"cluster", CLUSTER, UNRESERVED_KEYWORD}, {"coalesce", COALESCE, COL_NAME_KEYWORD}, {"collate", COLLATE, RESERVED_KEYWORD}, {"column", COLUMN, RESERVED_KEYWORD}, {"comment", COMMENT, UNRESERVED_KEYWORD}, {"commit", COMMIT, UNRESERVED_KEYWORD}, {"committed", COMMITTED, UNRESERVED_KEYWORD}, {"concurrently", CONCURRENTLY, UNRESERVED_KEYWORD}, {"configuration", CONFIGURATION, UNRESERVED_KEYWORD}, {"connect", CONNECT_EDB, RESERVED_KEYWORD}, /* EnterpriseDB Keyword */ {"connection", CONNECTION, UNRESERVED_KEYWORD}, {"constraint", CONSTRAINT, RESERVED_KEYWORD}, {"constraints", CONSTRAINTS, UNRESERVED_KEYWORD}, {"content", CONTENT_P, UNRESERVED_KEYWORD}, {"conversion", CONVERSION_P, UNRESERVED_KEYWORD}, {"convert", CONVERT_EDB, RESERVED_KEYWORD}, /* EnterpriseDB Keyword */ {"copy", COPY, UNRESERVED_KEYWORD}, {"cost", COST, UNRESERVED_KEYWORD}, {"create", CREATE, RESERVED_KEYWORD}, {"createdb", CREATEDB, UNRESERVED_KEYWORD}, {"createrole", CREATEROLE, UNRESERVED_KEYWORD}, {"createuser", CREATEUSER, UNRESERVED_KEYWORD}, {"cross", CROSS, TYPE_FUNC_NAME_KEYWORD}, {"csv", CSV, UNRESERVED_KEYWORD}, {"ctype", CTYPE, RESERVED_KEYWORD}, {"current", CURRENT_P, UNRESERVED_KEYWORD}, {"current_date", CURRENT_DATE, RESERVED_KEYWORD}, {"current_role", CURRENT_ROLE, RESERVED_KEYWORD}, {"current_time", CURRENT_TIME, RESERVED_KEYWORD}, {"current_timestamp", CURRENT_TIMESTAMP, RESERVED_KEYWORD}, {"current_user", CURRENT_USER, RESERVED_KEYWORD}, {"cursor", CURSOR, UNRESERVED_KEYWORD}, {"cycle", CYCLE, UNRESERVED_KEYWORD}, {"database", DATABASE, UNRESERVED_KEYWORD}, {"day", DAY_P, UNRESERVED_KEYWORD}, {"deallocate", DEALLOCATE, UNRESERVED_KEYWORD}, {"dec", DEC, COL_NAME_KEYWORD}, {"decimal", DECIMAL_P, COL_NAME_KEYWORD}, {"declare", DECLARE, UNRESERVED_KEYWORD}, {"default", DEFAULT, RESERVED_KEYWORD}, {"defaults", DEFAULTS, UNRESERVED_KEYWORD}, {"deferrable", DEFERRABLE, RESERVED_KEYWORD}, {"deferred", DEFERRED, UNRESERVED_KEYWORD}, {"definer", DEFINER, UNRESERVED_KEYWORD}, {"delete", DELETE_P, UNRESERVED_KEYWORD}, {"delimiter", DELIMITER, UNRESERVED_KEYWORD}, {"delimiters", DELIMITERS, UNRESERVED_KEYWORD}, {"desc", DESC, RESERVED_KEYWORD}, {"dictionary", DICTIONARY, UNRESERVED_KEYWORD}, {"disable", DISABLE_P, UNRESERVED_KEYWORD}, {"discard", DISCARD, UNRESERVED_KEYWORD}, {"distinct", DISTINCT, RESERVED_KEYWORD}, {"distributed", DISTRIBUTED_GP, UNRESERVED_KEYWORD}, /* Greenplum Keyword */ {"do", DO, RESERVED_KEYWORD}, {"document", DOCUMENT_P, UNRESERVED_KEYWORD}, {"domain", DOMAIN_P, UNRESERVED_KEYWORD}, {"double", DOUBLE_P, UNRESERVED_KEYWORD}, {"drop", DROP, UNRESERVED_KEYWORD}, {"each", EACH, UNRESERVED_KEYWORD}, {"else", ELSE, RESERVED_KEYWORD}, {"enable", ENABLE_P, UNRESERVED_KEYWORD}, {"encoding", ENCODING, UNRESERVED_KEYWORD}, {"encrypted", ENCRYPTED, UNRESERVED_KEYWORD}, {"end", END_P, RESERVED_KEYWORD}, {"enum", ENUM_P, UNRESERVED_KEYWORD}, {"escape", ESCAPE, UNRESERVED_KEYWORD}, {"except", EXCEPT, RESERVED_KEYWORD}, {"excluding", EXCLUDING, UNRESERVED_KEYWORD}, {"exclusive", EXCLUSIVE, UNRESERVED_KEYWORD}, {"exec", EXEC_EDB, RESERVED_KEYWORD}, /* EnterpriseDB Keyword */ {"execute", EXECUTE, UNRESERVED_KEYWORD}, {"exists", EXISTS, COL_NAME_KEYWORD}, {"explain", EXPLAIN, UNRESERVED_KEYWORD}, {"external", EXTERNAL, UNRESERVED_KEYWORD}, {"extract", EXTRACT, COL_NAME_KEYWORD}, {"false", FALSE_P, RESERVED_KEYWORD}, {"family", FAMILY, UNRESERVED_KEYWORD}, {"fetch", FETCH, UNRESERVED_KEYWORD}, {"fillfactor", FILLFACTOR, UNRESERVED_KEYWORD}, {"first", FIRST_P, UNRESERVED_KEYWORD}, {"float", FLOAT_P, COL_NAME_KEYWORD}, {"for", FOR, RESERVED_KEYWORD}, {"force", FORCE, UNRESERVED_KEYWORD}, {"foreign", FOREIGN, RESERVED_KEYWORD}, {"forward", FORWARD