-> To create the databse go to installation directory of postgres and create the database as follows.
cmd:/usr/local/pgsql/bin/createdb test1 -p 5432
-> To conncet to the database use the cmd as below.
cmd:/usr/local/pgsql/bin/psql test1 -p 5432
-> Now we can able to perform all DDL,DML,DQL,DCL on our database.
Create and connect to the Postgresql Database through cmd
Hannie
Uncategorized - November 21, 2017
- 0 Comments
Related Posts
- November 8, 2022
- 0 Comments
Vi editor in Linux
Its a visual editor by default installed in every linux system. The next version of vi is vim. The vi editor tool is an interactive tool as it displays changes…
- February 5, 2018
- 0 Comments
Monitoring in Postgresql
In normal PostgreSQL operation, tuples that are deleted or obsoleted by an update are not physically removed from their table. They remain present until a VACUUM is done. Therefore it’s necessary to do VACUUM periodically, especially…