ఆశీర్వదించు వెంకట రమణ మూర్తి

ఇది నా మొదటి పోస్ట్ postgresql నేర్చుకోవటం మరియు Knowledge gathering  లో. నీ అశీసులు కావాలి స్వామి. అమ్మ అయ్యా కి చేపి నాకు బాగా ఈ సబ్జెక్టు మీద knowledge వచ్చేటట్లు చేయి.

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

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

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