Please visit the official tutorial at. https://postgis.net/workshops/postgis-intro/