Tags » PostgreSQL

How to generate different sql scripts through pom.xml

In this post, we will see how to generate different sql scripts using our pom.xml from maven project with a little help from hibernate. 1,563 more words

Java

My "Must-see" List for PgOpen

PostgresOpen is coming up in just a few weeks! (Disclosure: I am on the conference committee.) We are still working out the room assignments; your conference badge/printed program will have the right info. 362 more words

PostgreSQL

PostgreSQL connection strings

https://www.connectionstrings.com/postgresql/

  • PostgreSQL ODBC Driver (psqlODBC)

    • Standard

      Driver={PostgreSQL};Server=IP address;Port=5432;Database=myDataBase;
      Uid=myUsername;Pwd=myPassword;

      PostgreSQL
    • ANSI

      Driver={PostgreSQL ANSI};Server=IP address;Port=5432;Database=myDataBase;
      Uid=myUsername;Pwd=myPassword;

      PostgreSQL
    • Unicode

      Driver={PostgreSQL UNICODE};Server=IP address;Port=5432;Database=myDataBase;
      Uid=myUsername;Pwd=myPassword;

      PostgreSQL
    • SSL

      Secure sockets layer for this driver only works from version 8.0 and above.

  • 33 more words
Postgresql

Export and import table dump (.sql) using pgAdmin

    In pgAdmin, select the required target scheme in object tree
    Click on Plugins/PSQL Console
    Write \i /path/to/yourfile.sql
    Press enter
Postgresql

How to drop & create db from backup ?


sudo service postgresql restart
dropdb -h localhost -p 5432 -U "postgres" "dbname"
createdb -h localhost -p 5432 -U "postgres" "dbname"
zcat /var/www/db-backup/dbname_2015_06_27.gz | psql -d dbname

Postgresql

Quick start on using Hibernate with Postgres 9.4 in IntelliJ

Preliminaries:
1. Install IntelliJ Ultimate. You can get a 30 day trial license.
2. Install PostgresSQL 9.4 or whatever is the latest version today.

What do do: 812 more words