Tags » PostgreSQL

PostgreSQL 9.3 Training Course | PostgreSQL Online Training from hyderabad india uk

PostgreSQL Training Online

PostgreSQL Trainng Course Duration: 25-30hrs

PostgreSQL Training Course Fee: $

PostgreSQL Training Pre-Requisites: 

  • Installing PostgreSQL on a Mac
  • Installing PostgreSQL on a PC…
  • 290 more words
PostgreSQL Database And Linux

Postgres login without password

In order to login to postgres without a password, you need to create a .pgpass file in your home directory. The contents of the file should look similar to: 72 more words

PostgreSQL

postgres: drop users with default privileges

For my rails app I need a couple users one is used when running and creating reports using sql. To avoid someone deleting data I wanted to give the ‘report’ user readonly capabilities. 145 more words

Postgresql

Export postgres database to sql file using linux terminal

If you want to create an sql dump of any of the postgres database using linux terminal then you can do that using ‘pg_dump’ command. 35 more words

Backup

Insert and Update multiple records at once

INSERT Statement
If you want to insert a numbers of records, try the following:

INSERT INTO TABLE_NAME1 ('COLUMN_A', 'COLUMN_B')
VALUES
(VALUE_A11, VALUE_B12),
(VALUE_A21, VALUE_B22);

For MySQL syntax, please visit… 131 more words

PostgreSQL

PDXPUGDay Recap

Last weekend we held the biggest PDXPUGDay we’ve had in a while! 5 speakers + a few lightning talks added up to a fun lineup. About 1/3 of the ~50 attendees were in town for… 550 more words

PostgreSQL

Delta Table Clean Up in Bucardo 5 Cascaded Slave Replication

Thanks to Bucardo team for responding my previous post. My cascaded slave replication works as expected.

Today I notice there is still something to do related with delta and track tables. 202 more words

PostgreSQL