sudo -u postgres psql
// Create New Database
CREATE DATABASE db_name;
// Create New User
CREATE USER username WITH PASSWORD password;
// Grant Admin Access ?
GRANT ALL PRIVILEGES ON DATABASE db_name TO username;| Code Example |
|---|
| Sql :: phone number regex sql |
| Sql :: show function mysql |
| Sql :: sql remove check constraint |
| Sql :: identity syntax in sql |
| Sql :: rand mysql |
| Sql :: sql insert into select |
| Sql :: insert into sql |
| Sql :: mysql remove database |
| Sql :: import csv to postgresql |
| Sql :: sql to linq |
| Sql :: postgresql héritage |
| Sql :: how to check user grant in mysql |
| Sql :: mysql insert rows to another database |
| Sql :: See Foreign Key |
| Sql :: dublicate row sql |
| Sql :: mysql group by |
| Sql :: mysqldump 1 table only |
| Sql :: sql date with month and year only |
| Sql :: when matched in sql server |
| Sql :: list mysql tables and views |
| Sql :: SQL FETCH FIRST Clause |
| Sql :: mysql sql.gz |
| Sql :: sql rename column in select |
| Sql :: sql use with to get value counts and percentages |
| Sql :: get last record deluge |
| Sql :: oracle boolean to varchar |
| Sql :: mssql coalesce |
| Sql :: drop domain postgresql |
| Sql :: cascade syntax in sql |
| Sql :: mysql delete duplicate rows except one |