PostgreSQL Tutorial 5 -- Creating the DB in Postgresql and Switching between DBs

A. Creating Database in Postgresql



B. Swithcing between DBs




Comments

Post a Comment

Popular posts from this blog

Postgresql Book References

Image
PostgreSQL -- Up and Running -- 1st Edition Url: https://drive.google.com/open?id=1cfZtwvN6MZDYxgSWR0cXxdgwd4TtghtG PostgreSQL -- Up and Running -- 2nd Edition Url: https://drive.google.com/open?id=1p6jNG6wyro-svzXfIKRGSsNoZddA4akh Beginning Databases with PostgreSQL -- From Novice to Professional (Beginning From Novice to Professional)  -- 2nd Edition Url: https://drive.google.com/open?id=1uQElel4BoIXGxqdqmYVbWToyYoRpoljA
Read more

PSQL Commands References

1. When we connect Postgresql with particular user, if the user is Superuser or has the privilege Create DB , then the prompt will like " =# " otherwise it will look like " => " .  2. How to write big queries in psql.  https://venkataramanapostgresqlreference.blogspot.com/2019/10/how-write-big-queries-in-psql.html 3. How to execute script file in PSQL. https://venkataramanapostgresqlreference.blogspot.com/2019/10/how-to-execute-script-file-in-psql.html   4. How to redirect the output to a text file in PSQL.  https://venkataramanapostgresqlreference.blogspot.com/2019/10/how-to-redirect-psql-output-to-text-file.html 5. PSQL command to know the details of the table details. https://venkataramanapostgresqlreference.blogspot.com/2019/10/psql-command-to-know-details-of-table.html
Read more

Postgresql Tools

pgAgent   pgAgent is a job scheduler for PostgreSQL which may be managed using pgAdmin. Prior to pgAdmin v1.9, pgAgent shipped as part of pgAdmin. From pgAdmin v1.9 onwards, pgAgent is shipped as a separate application. Please note that this is not at all working with PG Admin4. No help in internet. Hence, ignore this option. 
Read more