PostgreSQL Archives - Page 2 of 6

How To Create User With Superuser Privileges in PostgreSQL

You need to create superuser for database administration. Here is how to create user with superuser privileges in PostgreSQL.

Sometimes you may need to copy data from one table to another using SQL. Here is how to copy data from one table to another in SQL.

Sometimes you may need to find PostgreSQL version or get PostgreSQL version. Here is how to check PostgreSQL version for your database.

Sometimes you may need to change user to superuser in PostgreSQL. Here is alter user to superuser in PostgreSQL.

Sometimes you may need to restrict access to database in PostgreSQL. Here is how to limit access to database in PostgreSQL.

Here is how to change column from NULL to NOT NULL in SQL Server, MySQL, PostgreSQL using ALTER TABLE statement.

You can easily enable remote access in PostgreSQL databases. Here is how to setup remote connection in PostgreSQL.

Read Only user has limited permissions and database access. Here is how to create read only user in PostgreSQL for reporting purposes.