20.15 PostgreSQL Table Schema

$ psql -d sample_data
psql (12.4 (Ubuntu 12.4-0ubuntu0.20.04.1))
Type "help" for help.

sample_data=# SELECT column_name, data_type
sample_data-#  
sample_data-# WHERE  table_name = 'population_postcode';

     column_name     | data_type 
---------------------+-----------
 postcode            | integer
 population          | integer
(2 rows)

sample_data=# 

---

Your donation will support ongoing availability and give you access to the PDF version of this book. Desktop Survival Guides include Data Science, GNU/Linux, and MLHub. Books available on Amazon include Data Mining with Rattle and Essentials of Data Science. Popular open source software includes rattle, wajig, and mlhub. Hosted by Togaware, a pioneer of free and open source software since 1984. Copyright © 1995-2022 Graham.Williams@togaware.com Creative Commons Attribution-ShareAlike 4.0