david-sanabria

/*
 * This script will create base62_encode() and base62_decode() in the current schema of a postgresql database.
 * Give it a star if you find it useful.
 */

CREATE OR REPLACE FUNCTION base62_encode( long_number bigint ) 
RETURNS text
AS $BODY$
/*
 * base62_encode()

ictlyh

/*
 * Demo of libpq.
 * Build: g++ libpq-demo.cc -o libpq-demo -lpq
 * Run: ./libpq-demo
 */

#include <arpa/inet.h>
#include <iostream>
#include <libpq-fe.h>
#include <sstream>

Kartones

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)