postgreSQL usage
Basic usage comparing to mysql mysql: SHOW TABLES postgresql: \d postgresql: SELECT table_name FROM information_schema.tables WHERE table_schema = 'public'; mysql: SHOW DATABASES postgresql: \l postgresql: SELECT datname FROM pg_database; mysql: SHOW COLUMNS postgresql: \d table postgresql: SELECT column_name FROM information_schema.columns WHERE table_name =' table '; mysql: DESCRIBE TABLE postgresql: \d+ table postgresql: SELECT column_name FROM information_schema.columns WHERE table_name =' table '; Join usage Join 2 tables: SELECT A.pka, A.c1, B.pkb, B.c2 FROM A INNER JOIN B ON A .pka = B.fka; Join 3 tables : t1 and t3 merger to t2: SELECT t1.column1, t2.column2, t3.column3 FROM table1name t1 INNER JOI...