PostgreSQL Basic SQL

Create user and Password: Crate user username with password ' password '; create

Alter user username with password ' password '; Modify User Password

View user information: SELECT * from Pg_shadow;

Creating a library: Create Database dbname;

Switch Library: \c dbname

Creating tables: Create TABLE filename (id,name);

Authorization to the User: Grant all privileges the databases dbname to username;

View all libraries: \l

View all tables in the current library: \d

View table structure: \d filename

Create the database and specify the owner: Create databases dbname owner username;

View currently logged in User: Select User;

Remote Connection database: modifying pg_hba.conf and Postgresql.conf

Add a line under IPV4: Host all 0.0.0.0/24 MD5

The above line should read: Host all 0.0.0.0/24 Trust

PostgreSQL Basic SQL