Inserting rows using Select query results in PostgreSQL.

This blog post will cover using the query results of a SELECT statement from one table, as the values to INSERT, into another table.

(more…)

Advertisements

Fabulous fabrication asset tracking using JOINS in PostgreSQL

This post will demonstrate mock asset tracking with PostgreSQL for a pipe fabrication setting. The typical data one would track and record in this setting are bends, weld id’s, and joints of pipe. We will see powerful queries from multiple tables, return informative and useful data with the JOIN command.

(more…)

Use PostgreSQL Aggregate functions for inventory and asset tracking needs.

PostgreSQL’s Aggregate functions can be used to solve and answer many common questions and problems, allowing us to present our data in meaningful ways. Today we will look at an example of how to use some of these powerful functions for inventory or asset tracking needs.

(more…)