Go to TogaWare.com Home Page. GNU/Linux Desktop Survival Guide
by Graham Williams
Duck Duck Go



CLICK HERE TO VISIT THE UPDATED SURVIVAL GUIDE

PostgreSQL Scripts

20200819 PostgreSQL can run SQL script files from the command line using --file or -f. For example, in a text file like iris.sql we might have the following SQL commands:

DROP TABLE IF EXISTS iris;

CREATE TABLE iris(
  sepal_length numeric,
  sepal_width numeric,
  petal_length numeric,
  petal_width numeric,
  species text);

COPY iris FROM '/home/kayon/iris.csv' with (format csv, header true);

SELECT COUNT(*) FROM iris;

These commands can be run using:

$ psql -f iris.sql

DROP TABLE
CREATE TABLE
COPY 150
 count 
-------
   150
(1 row)


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.