Skip to content

Instantly share code, notes, and snippets.

View Ptopic's full-sized avatar

Petar Topić Ptopic

View GitHub Profile
const request = require('request');
// Define the message payload
const message = {
data: {
title: 'New message received!',
body: 'Hello, how are you?'
},
to: 'device-token-here'
};
@apolloclark
apolloclark / postgres cheatsheet.md
Last active October 31, 2025 06:15
postgres cheatsheet

Postgres Cheatsheet

This is a collection of the most common commands I run while administering Postgres databases. The variables shown between the open and closed tags, "<" and ">", should be replaced with a name you choose. Postgres has multiple shortcut functions, starting with a forward slash, "". Any SQL command that is not a shortcut, must end with a semicolon, ";". You can use the keyboard UP and DOWN keys to scroll the history of previous commands you've run.

Setup

installation, Ubuntu

http://www.postgresql.org/download/linux/ubuntu/ https://help.ubuntu.com/community/PostgreSQL