keywords

Documentation

Overview

Package keywords pulls some postgres specific functionality.

Keywords were gathered from https://www.postgresql.org/docs/current/sql-keywords-appendix.html on 4/23/21.

Index

• Constants
• func CanBeFunctionOrTypeName(s string) bool
• func ForEach(f func(s string) bool)
• func IsReserved(s string) bool
• func IsToken(s string) bool

Constants

const (
	All              util.V = "ALL"
	Analyse          util.V = "ANALYSE"
	Analyze          util.V = "ANALYZE"
	And              util.V = "AND"
	Any              util.V = "ANY"
	Array            util.V = "ARRAY"
	As               util.V = "AS"
	Asc              util.V = "ASC"
	Asymmetric       util.V = "ASYMMETRIC"
	Both             util.V = "BOTH"
	Case             util.V = "CASE"
	Cast             util.V = "CAST"
	Check            util.V = "CHECK"
	Collate          util.V = "COLLATE"
	Column           util.V = "COLUMN"
	Constraint       util.V = "CONSTRAINT"
	Create           util.V = "CREATE"
	CurrentCatalog   util.V = "CURRENT_CATALOG"
	CurrentDate      util.V = "CURRENT_DATE"
	CurrentRole      util.V = "CURRENT_ROLE"
	CurrentTime      util.V = "CURRENT_TIME"
	CurrentTimestamp util.V = "CURRENT_TIMESTAMP"
	CurrentUser      util.V = "CURRENT_USER"
	Default          util.V = "DEFAULT"
	Deferrable       util.V = "DEFERRABLE"
	Desc             util.V = "DESC"
	Distinct         util.V = "DISTINCT"
	Do               util.V = "DO"
	Else             util.V = "ELSE"
	End              util.V = "END"
	Except           util.V = "EXCEPT"
	False            util.V = "FALSE"
	Fetch            util.V = "FETCH"
	For              util.V = "FOR"
	Foreign          util.V = "FOREIGN"
	From             util.V = "FROM"
	Grant            util.V = "GRANT"
	Group            util.V = "GROUP"
	Having           util.V = "HAVING"
	In               util.V = "IN"
	Initially        util.V = "INITIALLY"
	Intersect        util.V = "INTERSECT"
	Into             util.V = "INTO"
	Lateral          util.V = "LATERAL"
	Leading          util.V = "LEADING"
	Limit            util.V = "LIMIT"
	Localtime        util.V = "LOCALTIME"
	LocalTimestamp   util.V = "LOCALTIMESTAMP"
	Not              util.V = "NOT"
	Null                    = keywords.Null
	Offset           util.V = "OFFSET"
	On               util.V = "ON"
	Only             util.V = "ONLY"
	Or               util.V = "OR"
	Order            util.V = "ORDER"
	Placing          util.V = "PLACING"
	Primary          util.V = "PRIMARY"
	References       util.V = "REFERENCES"
	Returning        util.V = "RETURNING"
	Select           util.V = "SELECT"
	SessionUser      util.V = "SESSION_USER"
	Some             util.V = "SOME"
	Symmetric        util.V = "SYMMETRIC"
	Table            util.V = "TABLE"
	Then             util.V = "THEN"
	To               util.V = "TO"
	Trailing         util.V = "TRAILING"
	True             util.V = "TRUE"
	Union            util.V = "UNION"
	Unique           util.V = "UNIQUE"
	User             util.V = "USER"
	Using            util.V = "USING"
	Variadic         util.V = "VARIADIC"
	When             util.V = "WHEN"
	Where            util.V = "WHERE"
	Window           util.V = "WINDOW"
	With             util.V = "WITH"
)

Reserved Keywords. In Postgres, reserved key words can be used as column labels in an AS statement, but nowhere else.

const (
	Authorization util.V = "AUTHORIZATION"
	Binary        util.V = "BINARY"
	Collation     util.V = "COLLATION"
	Concurrently  util.V = "CONCURRENTLY"
	Cross         util.V = "CROSS"
	CurrentSchema util.V = "CURRENT_SCHEMA"
	Freeze        util.V = "FREEZE"
	Full          util.V = "FULL"
	ILike         util.V = "ILIKE"
	Inner         util.V = "INNER"
	Is            util.V = "IS"
	IsNull        util.V = "ISNULL"
	Join          util.V = "JOIN"
	Left          util.V = "LEFT"
	Like          util.V = "LIKE"
	Natural       util.V = "NATURAL"
	NotNull       util.V = "NOTNULL"
	Outer         util.V = "OUTER"
	Overlaps      util.V = "OVERLAPS"
	Right         util.V = "RIGHT"
	Similar       util.V = "SIMILAR"
	TableSample   util.V = "TABLESAMPLE"
	Verbose       util.V = "VERBOSE"
)

Reserved (can be function or type)

const (
	Between       util.V = "BETWEEN"
	BigInt        util.V = "BIGINT"
	Bit           util.V = "BIT"
	Boolean       util.V = "BOOLEAN"
	Char          util.V = "CHAR"
	Character     util.V = "CHARACTER"
	Coalesce      util.V = "COALESCE"
	Dec           util.V = "DEC"
	Decimal       util.V = "DECIMAL"
	Exists        util.V = "EXISTS"
	Extract       util.V = "EXTRACT"
	Float         util.V = "FLOAT"
	Greatest      util.V = "GREATEST"
	Grouping      util.V = "GROUPING"
	InOut         util.V = "INOUT"
	Int           util.V = "INT"
	Integer       util.V = "INTEGER"
	Interval      util.V = "INTERVAL"
	Least         util.V = "LEAST"
	National      util.V = "NATIONAL"
	Nchar         util.V = "NCHAR"
	None          util.V = "NONE"
	Normalize     util.V = "NORMALIZE"
	NullIf        util.V = "NULLIF"
	Numeric       util.V = "NUMERIC"
	Out           util.V = "OUT"
	Overlay       util.V = "OVERLAY"
	Position      util.V = "POSITION"
	Precision     util.V = "PRECISION"
	Real          util.V = "REAL"
	Row           util.V = "ROW"
	SetOf         util.V = "SETOF"
	SmallInt      util.V = "SMALLINT"
	Substring     util.V = "SUBSTRING"
	Time          util.V = "TIME"
	Timestamp     util.V = "TIMESTAMP"
	Treat         util.V = "TREAT"
	Trim          util.V = "TRIM"
	Values        util.V = "VALUES"
	Varchar       util.V = "VARCHAR"
	XmlAttributes util.V = "XMLATTRIBUTES"
	XmlConcat     util.V = "XMLCONCAT"
	XmlElement    util.V = "XMLELEMENT"
	XmlExists     util.V = "XMLEXISTS"
	XmlForest     util.V = "XMLFOREST"
	XmlNamespaces util.V = "XMLNAMESPACES"
	XmlParse      util.V = "XMLPARSE"
	XmlPi         util.V = "XMLPI"
	XmlRoot       util.V = "XMLROOT"
	XmlSerialize  util.V = "XMLSERIALIZE"
	XmlTable      util.V = "XMLTABLE"
)

Reserved (cannot be function or type)

const (
	Abort           util.V = "ABORT"
	Absolute        util.V = "ABSOLUTE"
	Access          util.V = "ACCESS"
	Action          util.V = "ACTION"
	Add             util.V = "ADD"
	Admin           util.V = "ADMIN"
	After           util.V = "AFTER"
	Aggregate       util.V = "AGGREGATE"
	Also            util.V = "ALSO"
	Alter           util.V = "ALTER"
	Always          util.V = "ALWAYS"
	Assertion       util.V = "ASSERTION"
	Assignment      util.V = "ASSIGNMENT"
	At              util.V = "AT"
	Attach          util.V = "ATTACH"
	Attribute       util.V = "ATTRIBUTE"
	Backward        util.V = "BACKWARD"
	Before          util.V = "BEFORE"
	Begin           util.V = "BEGIN"
	By              util.V = "BY"
	Cache           util.V = "CACHE"
	Call            util.V = "CALL"
	Called          util.V = "CALLED"
	Cascade         util.V = "CASCADE"
	Cascaded        util.V = "CASCADED"
	Catalog         util.V = "CATALOG"
	Chain           util.V = "CHAIN"
	Characteristics util.V = "CHARACTERISTICS"
	Checkpoint      util.V = "CHECKPOINT"
	Class           util.V = "CLASS"
	Close           util.V = "CLOSE"
	Cluster         util.V = "CLUSTER"
	Columns         util.V = "COLUMNS"
	Comment         util.V = "COMMENT"
	Comments        util.V = "COMMENTS"
	Commit          util.V = "COMMIT"
	Committed       util.V = "COMMITTED"
	Configuration   util.V = "CONFIGURATION"
	Conflict        util.V = "CONFLICT"
	Connection      util.V = "CONNECTION"
	Constraints     util.V = "CONSTRAINTS"
	Content         util.V = "CONTENT"
	Continue        util.V = "CONTINUE"
	Conversion      util.V = "CONVERSION"
	Copy            util.V = "COPY"
	Cost            util.V = "COST"
	Csv             util.V = "CSV"
	Cube            util.V = "CUBE"
	Current         util.V = "CURRENT"
	Cursor          util.V = "CURSOR"
	Cycle           util.V = "CYCLE"
	Data            util.V = "DATA"
	Database        util.V = "DATABASE"
	Day             util.V = "DAY"
	Deallocate      util.V = "DEALLOCATE"
	Declare         util.V = "DECLARE"
	Defaults        util.V = "DEFAULTS"
	Deferred        util.V = "DEFERRED"
	Definer         util.V = "DEFINER"
	Delete          util.V = "DELETE"
	Delimiter       util.V = "DELIMITER"
	Delimiters      util.V = "DELIMITERS"
	Depends         util.V = "DEPENDS"
	Detach          util.V = "DETACH"
	Dictionary      util.V = "DICTIONARY"
	Disable         util.V = "DISABLE"
	Discard         util.V = "DISCARD"
	Document        util.V = "DOCUMENT"
	Domain          util.V = "DOMAIN"
	Double          util.V = "DOUBLE"
	Drop            util.V = "DROP"
	Each            util.V = "EACH"
	Enable          util.V = "ENABLE"
	Encoding        util.V = "ENCODING"
	Encrypted       util.V = "ENCRYPTED"
	Enum            util.V = "ENUM"
	Escape          util.V = "ESCAPE"
	Event           util.V = "EVENT"
	Exclude         util.V = "EXCLUDE"
	Excluding       util.V = "EXCLUDING"
	Exclusive       util.V = "EXCLUSIVE"
	Execute         util.V = "EXECUTE"
	Explain         util.V = "EXPLAIN"
	Expression      util.V = "EXPRESSION"
	Extension       util.V = "EXTENSION"
	External        util.V = "EXTERNAL"
	Family          util.V = "FAMILY"
	Filter          util.V = "FILTER"
	First           util.V = "FIRST"
	Following       util.V = "FOLLOWING"
	Force           util.V = "FORCE"
	Forward         util.V = "FORWARD"
	Function        util.V = "FUNCTION"
	Functions       util.V = "FUNCTIONS"
	Generated       util.V = "GENERATED"
	Global          util.V = "GLOBAL"
	Granted         util.V = "GRANTED"
	Groups          util.V = "GROUPS"
	Handler         util.V = "HANDLER"
	Header          util.V = "HEADER"
	Hold            util.V = "HOLD"
	Hour            util.V = "HOUR"
	Identity        util.V = "IDENTITY"
	If              util.V = "IF"
	Immediate       util.V = "IMMEDIATE"
	Immutable       util.V = "IMMUTABLE"
	Implicit        util.V = "IMPLICIT"
	Import          util.V = "IMPORT"
	Include         util.V = "INCLUDE"
	Including       util.V = "INCLUDING"
	Increment       util.V = "INCREMENT"
	Index           util.V = "INDEX"
	Indexes         util.V = "INDEXES"
	Inherit         util.V = "INHERIT"
	Inherits        util.V = "INHERITS"
	Inline          util.V = "INLINE"
	Input           util.V = "INPUT"
	Insensitive     util.V = "INSENSITIVE"
	Insert          util.V = "INSERT"
	Instead         util.V = "INSTEAD"
	Invoker         util.V = "INVOKER"
	Isolation       util.V = "ISOLATION"
	Key             util.V = "KEY"
	Label           util.V = "LABEL"
	Language        util.V = "LANGUAGE"
	Large           util.V = "LARGE"
	Last            util.V = "LAST"
	LeakProof       util.V = "LEAKPROOF"
	Level           util.V = "LEVEL"
	Listen          util.V = "LISTEN"
	Load            util.V = "LOAD"
	Local           util.V = "LOCAL"
	Location        util.V = "LOCATION"
	Lock            util.V = "LOCK"
	Locked          util.V = "LOCKED"
	Logged          util.V = "LOGGED"
	Mapping         util.V = "MAPPING"
	Match           util.V = "MATCH"
	Materialized    util.V = "MATERIALIZED"
	MaxValue        util.V = "MAXVALUE"
	Method          util.V = "METHOD"
	Minute          util.V = "MINUTE"
	Minvalue        util.V = "MINVALUE"
	Mode            util.V = "MODE"
	Month           util.V = "MONTH"
	Move            util.V = "MOVE"
	Name            util.V = "NAME"
	Names           util.V = "NAMES"
	New             util.V = "NEW"
	Next            util.V = "NEXT"
	NFC             util.V = "NFC"
	NFD             util.V = "NFD"
	NFKC            util.V = "NFKC"
	NFKD            util.V = "NFKD"
	No              util.V = "NO"
	Normalized      util.V = "NORMALIZED"
	Nothing         util.V = "NOTHING"
	Notify          util.V = "NOTIFY"
	NoWait          util.V = "NOWAIT"
	Nulls           util.V = "NULLS"
	Object          util.V = "OBJECT"
	Of              util.V = "OF"
	Off             util.V = "OFF"
	Oids            util.V = "OIDS"
	Old             util.V = "OLD"
	Operator        util.V = "OPERATOR"
	Option          util.V = "OPTION"
	Options         util.V = "OPTIONS"
	Ordinality      util.V = "ORDINALITY"
	Others          util.V = "OTHERS"
	Over            util.V = "OVER"
	Overriding      util.V = "OVERRIDING"
	Owned           util.V = "OWNED"
	Owner           util.V = "OWNER"
	Parallel        util.V = "PARALLEL"
	Parser          util.V = "PARSER"
	Partial         util.V = "PARTIAL"
	Partition       util.V = "PARTITION"
	Passing         util.V = "PASSING"
	Password        util.V = "PASSWORD"
	Plans           util.V = "PLANS"
	Policy          util.V = "POLICY"
	Preceding       util.V = "PRECEDING"
	Prepare         util.V = "PREPARE"
	Prepared        util.V = "PREPARED"
	Preserve        util.V = "PRESERVE"
	Prior           util.V = "PRIOR"
	Privileges      util.V = "PRIVILEGES"
	Procedural      util.V = "PROCEDURAL"
	Procedure       util.V = "PROCEDURE"
	Procedures      util.V = "PROCEDURES"
	Program         util.V = "PROGRAM"
	Publication     util.V = "PUBLICATION"
	Quote           util.V = "QUOTE"
	Range           util.V = "RANGE"
	Read            util.V = "READ"
	Reassign        util.V = "REASSIGN"
	Recheck         util.V = "RECHECK"
	Recursive       util.V = "RECURSIVE"
	Ref             util.V = "REF"
	Referencing     util.V = "REFERENCING"
	Refresh         util.V = "REFRESH"
	Reindex         util.V = "REINDEX"
	Relative        util.V = "RELATIVE"
	Release         util.V = "RELEASE"
	Rename          util.V = "RENAME"
	Repeatable      util.V = "REPEATABLE"
	Replace         util.V = "REPLACE"
	Replica         util.V = "REPLICA"
	Reset           util.V = "RESET"
	Restart         util.V = "RESTART"
	Restrict        util.V = "RESTRICT"
	Returns         util.V = "RETURNS"
	Revoke          util.V = "REVOKE"
	Role            util.V = "ROLE"
	Rollback        util.V = "ROLLBACK"
	Rollup          util.V = "ROLLUP"
	Routine         util.V = "ROUTINE"
	Routines        util.V = "ROUTINES"
	Rows            util.V = "ROWS"
	Rule            util.V = "RULE"
	Savepoint       util.V = "SAVEPOINT"
	Schema          util.V = "SCHEMA"
	Schemas         util.V = "SCHEMAS"
	Scroll          util.V = "SCROLL"
	Search          util.V = "SEARCH"
	Second          util.V = "SECOND"
	Security        util.V = "SECURITY"
	Sequence        util.V = "SEQUENCE"
	Sequences       util.V = "SEQUENCES"
	Serializable    util.V = "SERIALIZABLE"
	Server          util.V = "SERVER"
	Session         util.V = "SESSION"
	Set             util.V = "SET"
	Sets            util.V = "SETS"
	Share           util.V = "SHARE"
	Show            util.V = "SHOW"
	Simple          util.V = "SIMPLE"
	Skip            util.V = "SKIP"
	Snapshot        util.V = "SNAPSHOT"
	Sql             util.V = "SQL"
	Stable          util.V = "STABLE"
	Standalone      util.V = "STANDALONE"
	Start           util.V = "START"
	Statement       util.V = "STATEMENT"
	Statistics      util.V = "STATISTICS"
	Stdin           util.V = "STDIN"
	Stdout          util.V = "STDOUT"
	Storage         util.V = "STORAGE"
	Stored          util.V = "STORED"
	Strict          util.V = "STRICT"
	Strip           util.V = "STRIP"
	Subscription    util.V = "SUBSCRIPTION"
	Support         util.V = "SUPPORT"
	Sysid           util.V = "SYSID"
	System          util.V = "SYSTEM"
	Tables          util.V = "TABLES"
	Tablespace      util.V = "TABLESPACE"
	Temp            util.V = "TEMP"
	Template        util.V = "TEMPLATE"
	Temporary       util.V = "TEMPORARY"
	Text            util.V = "TEXT"
	Ties            util.V = "TIES"
	Transaction     util.V = "TRANSACTION"
	Transform       util.V = "TRANSFORM"
	Trigger         util.V = "TRIGGER"
	Truncate        util.V = "TRUNCATE"
	Trusted         util.V = "TRUSTED"
	Type            util.V = "TYPE"
	Types           util.V = "TYPES"
	Uescape         util.V = "UESCAPE"
	Unbounded       util.V = "UNBOUNDED"
	Uncommitted     util.V = "UNCOMMITTED"
	Unencrypted     util.V = "UNENCRYPTED"
	Unknown         util.V = "UNKNOWN"
	Unlisten        util.V = "UNLISTEN"
	Unlogged        util.V = "UNLOGGED"
	Until           util.V = "UNTIL"
	Update          util.V = "UPDATE"
	Vacuum          util.V = "VACUUM"
	Valid           util.V = "VALID"
	Validate        util.V = "VALIDATE"
	Validator       util.V = "VALIDATOR"
	Value           util.V = "VALUE"
	Varying         util.V = "VARYING"
	Version         util.V = "VERSION"
	View            util.V = "VIEW"
	Views           util.V = "VIEWS"
	Volatile        util.V = "VOLATILE"
	Whitespace      util.V = "WHITESPACE"
	Within          util.V = "WITHIN"
	Without         util.V = "WITHOUT"
	Work            util.V = "WORK"
	Wrapper         util.V = "WRAPPER"
	Write           util.V = "WRITE"
	Xml             util.V = "XML"
	Year            util.V = "YEAR"
	Yes             util.V = "YES"
	Zone            util.V = "ZONE"
)

Non-reserved

Functions

func CanBeFunctionOrTypeName

func CanBeFunctionOrTypeName(s string) bool

func ForEach

func ForEach(f func(s string) bool)

ForEach loops over all known keywords until f returns false, or there are no more keywords left.

func IsReserved

func IsReserved(s string) bool

IsReserved returns true if s is a reserved word in Postgres. Note: Postgres allows reserved words to be used in many contexts.

func IsToken

func IsToken(s string) bool