Postgresql Basic Select,Insert,Update,Delete Command

POSTGRESQL connect db, list database, show tables, select, update, delete, begin ve commit komutları aşağıdaki gibi kullanılmaktadır. virtualm:~$ su – postgres postgres@virtualm:~$ psql postgres=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges ————-+———-+———-+————+————+———————– postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 | template0 | postgres | […]

Read More

Ubuntu Versiyonlarına PostgreSQL 9.6 nasıl yüklenir?

You need to add the latest PostgreSQL repository for the latest version. sudo add-apt-repository “deb https://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main” Update and Install PostgreSQL 9.6: sudo apt-get updatesudo apt-get install postgresql-9.6 Default postgres super user and postgres database is created. You need to set a password for the postgres super user. ubuntu@:~$ sudo passwd postgres Enter new […]

Read More