PGSQL commands !!!

1. How to check POstgresql version. [root@BMDB-02 ~]# psql –version psql (PostgreSQL) 8.1.11 ================= 2. How to create postgreSQL USER ? /usr/local/pgsql/bin/createuser skadam Shall the new role be a superuser? (y/n) n Shall the new role be allowed to create databases? (y/n) n Shall the new role be allowed to create more new roles? (y/n) […]

See More