Skip to main content

Posts

Top PostgreSQL Commands You Must Know

  Top PostgreSQL Commands You Must Know Jan 30, 2023 Table Of Contents show PostgreSQL Commands List 1. Connect to PostgreSQL Database 2. Change the database connection to a new one 3. List available database 4. List available table 5. Describe table 6. List available schema 7. List available function 8. List all views 9. List users and roles 10. Execute the previous command 11. Command History 12. Execute psql commands 13. Get help on psql commands 14. Turn on query execution time 15. Edit command in your editor 16. Switch output options 17. Quit psql FAQs Additional Resources PostgreSQL is a powerful, open-source object-relational database system that has a solid reputation for stability, feature robustness, and performance after more than 30 years of active development. PostgreSQL is used to store, manipulate and display the data in an application.PostgreSQL is used as a primary database for many web and mobile applications. PostgreSQL is very popular in tech giants like Apple which

What Is Python Used For? A Beginner’s Guide

  What Is Python Used For? A Beginner’s Guide Written by Ashutosh • Updated on Jan 26 , 2023 Share Python has become one of the most popular programming languages in the world in recent years. It's used in everything from machine learning to building websites and software testing. It can be used by developers and non-developers a like. Python, one of the most popular programming languages in the world, has created everything from Netflix’s recommendation algorithm to the software that controls self-driving cars. Python is a general-purpose language, which means it’s designed to be used in a range of applications, including  data science ,  software and web development ,  automation , and generally getting stuff done. Let’s take a closer look at what Python is, what it can do, and how you can start learning it. What is Python? Python is a computer programming language often used to build websites and software, automate tasks, and conduct data analysis. Python is a general-purpose la

How to use CMD

  Opening a Command Prompt Example   # The command prompt comes pre-installed on all Windows NT, Windows CE, OS/2 and eComStation operating systems, and exists as  cmd.exe , typically located in  C:\Windows\system32\cmd.exe On Windows 7 the fastest ways to open the command prompt are: Press  , type "cmd" and then press  Enter . Press  + R , type "cmd" then then press  Enter . It can also be opened by navigating to the executable and double-clicking on it. In some cases you might need to run  cmd  with elevated permissions, in this case right click and select "Run as administrator". This can also be achieved by pressing  Control +  Shift + Enter  instead of  Enter . download here