PostgreSQL Table Schema

		GNU/Linux Desktop Survival Guide by Graham Williams

CLICK HERE TO VISIT THE UPDATED SURVIVAL GUIDE

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-# FROM   information_schema.columns
sample_data-# WHERE  table_name = 'population_postcode';

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

sample_data=#

Support further development by purchasing the PDF version of the book.
Other online resources include the Data Science Desktop Survival Guide.
Books available on Amazon include Data Mining with Rattle and Essentials of Data Science.
Popular open source software includes rattle and wajig.
Hosted by Togaware, a pioneer of free and open source software since 1984.
Copyright © 1995-2020 Togaware Pty Ltd. Creative Commons ShareAlike V4.