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 - 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.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Input queries from the command line2m 52s
-
(Locked)
Format aligned text output5m 15s
-
(Locked)
Output results to external files5m 30s
-
(Locked)
Save query results to .csv3m 28s
-
(Locked)
Output HTML and LaTeX tables3m 20s
-
(Locked)
Export files from the command line1m 48s
-
(Locked)
Challenge: Export a data table50s
-
(Locked)
Solution: Export a data table6m
-
(Locked)
-
-