From the course: PostgreSQL: Client Applications

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Challenge: Export a data table

Challenge: Export a data table - PostgreSQL Tutorial

From the course: PostgreSQL: Client Applications

Challenge: Export a data table

(upbeat music) - [Instructor] It's time to test what you've learned with another challenge. For this challenge I'd like you to combine everything that you've seen in order to export a data file from the two trees database that meets the following criteria. The table should display all of the products with a category ID equal to three, this should return seven rows of data from the database. The output file needs to include a title, the results should be formatted as an HTML table, the table should not have a border, and the final requirement, I'd like you to perform all of these tasks with a single command sent from your systems command line. I estimate that this challenge should take about five minutes to complete, good luck.

Contents