Introduction to PostgreSQL
Introduction to PostgreSQL CREATOR: Amruta Ashish Pednekar What is PostgresQL ? Database For Storing Data Database system which stores data into tables for easy access Install PostgresQL Go to https://www.postgresql.org/download/ Select your opening system family Download installer Click on downloaded installer and run as administrator Enter admin password. It will start installation. Click on NEXT button after every step It will ask you for a password for database superuser . Enter and note is somewhere for future use Check below option Finish installation Starting PGAdmin Go to path where you installed PostgreSQL Go to <version> -> PGAdmin -> bin Open pgAdmin4 Set a master password for pgAdmin Connect to server Go to the left panel. Click on to servers Select server . Its PostgreSQL<version> Enter the same password you set while PostgreSQL installation Once you are connected to server, you can see other dropdowns like Tablespaces If you fac...