Wednesday 13 July 2016

what is postgreSQL

What is postgreSQL?


PostgreSQL is a Relational Database Management System(RDBMS) is a named collection of SQL objects. It is a collection of schemas and the schemas contain the tables, functions, etc.
  • Databases are created with the CREATE DATABASE command and
  • Databases are destroyed with the DROP DATABASE command.
To determine the set of existing databases:
-SQL: SELECT datname FROM pg_database;
Above command will list all the databases
-psql META COMMAND: \l(backslash lowercase L)
Using \l also we can list all the databases

No comments:

Post a Comment