20.14 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)

---

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