Skip to content

Instantly share code, notes, and snippets.

@dohsimpson

dohsimpson/PostgreSQL Commands.markdown

Last active July 27, 2017 15:02
Show Gist options
  • Save dohsimpson/321b10ba77a8ba4954859d596bc5ea7b to your computer and use it in GitHub Desktop.
Save dohsimpson/321b10ba77a8ba4954859d596bc5ea7b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
PostgreSQL Commands.markdown

Built-in Functions

about

  • version(): get the version of the DB server

datetime

  • date_trunc('second', TIMESTAMP): remove the milleseconds

Random Knowledge

Object Identifier Types (https://www.postgresql.org/docs/9.6/static/datatype-oid.html)

oid any numeric object identifier 564182 regproc pg_proc function name sum regprocedure pg_proc function with argument types sum(int4) regoper pg_operator operator name + regoperator pg_operator operator with argument types *(integer,integer) or -(NONE,integer) regclass pg_class relation name pg_type regtype pg_type data type name integer regrole pg_authid role name smithee regnamespace pg_namespace namespace name pg_catalog regconfig pg_ts_config text search configuration english regdictionary pg_ts_dict text search dictionary simple

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment