CoCalc command line test of postgresql with jdbc
follow instructions for 2 minute install of postgresql, including creating a tiny database
test
if you plan to use LibreOffice
Base
to browse the database, add a primary key to the table before running Basestop the database server
modify
/home/user/postgres_data/postgresql.conf
to use a TCP port by changing the end of the file:start the database server and look at
test
dbdownload PostgreSQL JDBC 4.2 Driver, 42.2.5 to ~/pgjar
edit JDBCExample.java; code is based on examples at Connect to PostgreSQL with JDBC driver and JDBC - Select Records Example
compile and run the test program
additional references
LibreOffice 4.0 Base Handbook pdf (260 pp)
W3Schools SQL Tutorial