/psqlpod

Primary LanguageDockerfileBSD 3-Clause "New" or "Revised" LicenseBSD-3-Clause

psqlpod

postgress image

Open in Gitpod

psql -h localhost -d postgres

CREATE TABLE basic (
	mykey varchar (50) NOT NULL PRIMARY KEY,
	name varchar (25) NOT NULL
	);

\d
\q

cat  a.csv
1,a
2,b
3,c
4,a
5,a
6,a

psql -h localhost -c "\copy basic FROM './a.csv' delimiter ',' csv"
psql -h localhost -c "select * from basic"
psql -h localhost -c "select distinct(name) from basic"