Tags » PostgreSQL

Execute this commands as postgres (root user on the DB), in order to change the ownership of a table:

ALTER table  owner to ;
 6 more words
How To

Execute these commands as postgres (root user on the DB).

Privilege to be granted: All
Object Affected: Tables of a Schema

GRANT ALL ON ALL TABLES IN SCHEMA  to ;
… 27 more words
How To

Install Postgres On Ubuntu

Start with Installing PostgreSql
sudo apt-get install postgresql postgresql-contrib

next to do : Login with admin user    sudo -u postgres psql

\du : to check user available in postgressql… 48 more words

Home Page

PostgreSQL vs. MS SQL Server

A comparison of two relational databases from the point of view of a data analyst. Original Post>>

SQL

Meet BART – A New Tool for Backup And Recovery Management

EnterpriseDB recently launched a new tool for backup and recovery – named simply EDB Backup and Recovery Tool, or BART. This tool makes the DBA’s life easier by simplifying the tasks for managing their Postgres physical backup and recovery tasks, whether they are PostgreSQL or Postgres Plus Advanced Server deployments. 1,205 more words

PostgreSQL