Skip to content

Instantly share code, notes, and snippets.

View KevinMcGovern's full-sized avatar

Kevin McGovern KevinMcGovern

  • Toronto, Canada
View GitHub Profile
@KevinMcGovern
KevinMcGovern / PostgreSQL_index_naming.rst
Created June 3, 2020 13:06 — forked from popravich/PostgreSQL_index_naming.rst
PostgreSQL index naming convention to remember

The standard names for indexes in PostgreSQL are:

{tablename}_{columnname(s)}_{suffix}

where the suffix is one of the following:

  • pkey for a Primary Key constraint;
  • key for a Unique constraint;
  • excl for an Exclusion constraint;
  • idx for any other kind of index;
@KevinMcGovern
KevinMcGovern / 0_reuse_code.js
Created November 18, 2015 15:03
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console