Date/Time Processing and Querying
Learn about data types for date and time in PostgreSQL.
Once the application’s data, or rather the user data, is properly stored as a timestamp with time zone, PostgreSQL allows us to implement all the processing we need to.
Using git
repository
As an example dataset, we’re playing with git
history this time. The PostgreSQL and the pgloader
project history have been loaded into the commitlog
table thanks to the git log
command, with a custom format and some post-processing—properly splitting up the commit’s subjects and escaping its content. Here’s, for example, the most recent commit registered in our local commitlog
table:
Get hands-on with 1200+ tech skills courses.