Archives for Pedro-Juan Ferrer Matoses

Adding a header and footer

Adding bookmarks using GS

Extract pages

Reduce the size

Remove password

Trace all the fonts

Adding a legend to a map

Adding margins to an image to match a A4 pdf

Crop an imagen

Get a colour histogram from an image

Getting information from an image

Preparing a set of counters

Resizing of images

Split an A3 in 4 A4

Tranforming a JPG into a PDF

Transforming GIF to PNG

Convert DOCX to RST

Change owner of all the tables and sequences

Convert a resultset into a comma separated field

Copying data

Creating a Postgis Template

Database dump using gzip

Feature table with triggers

Find first non null column

Generate series

Grant for a user on all tables

Hexgrids in Postgis

Insert from an Union

Moving the database cluster

Multipart to singlepart

Renumbering the results on criteria change

Split of a coordinate field

Text formatting

Update a geometry for a translation

Updating geo tables with temp tables

Using crosstab in the proper way

Comparing text files in bash

Git Basics

Git Going back

Git Remotes

Git Tags

Using fit in timeseries

Mounting a lan drive with cifs

Mounting a ndas with a windows fs

Mounting ntfs units

Counter in JINJA2

Embebed graphs using pygal

Flask - Migrate

A good grep command

Alignement Error

Basic Byobu/Screen

Byobu on startup

Disk formating using FAT32

Getting the name and duration of the videos in a folder

Getting the name and extension of an archive

Permissions on www-pub

Remove duplicate lines from a file

What does $0 and $1 mean