Installing Postgre SQL, Creating the DB and restoring the DB

Installing PostgreSQL 















DB Creation and Restore










Comments

Post a Comment

Popular posts from this blog

Postgresql Book References

Image
PostgreSQL -- Up and Running -- 1st Edition Url: https://drive.google.com/open?id=1cfZtwvN6MZDYxgSWR0cXxdgwd4TtghtG PostgreSQL -- Up and Running -- 2nd Edition Url: https://drive.google.com/open?id=1p6jNG6wyro-svzXfIKRGSsNoZddA4akh Beginning Databases with PostgreSQL -- From Novice to Professional (Beginning From Novice to Professional)  -- 2nd Edition Url: https://drive.google.com/open?id=1uQElel4BoIXGxqdqmYVbWToyYoRpoljA
Read more

How to connect postgresql database through ODBC driver in excel

Image
Postgresql has ODBC driver " psqlodbc " which will be used to connect to postgresql databases. In this post, we are connecting to postgresql from excel using ODBC driver.  Step1: Verifying the existing ODBC driver in windows (both 32 and 64 bit driver) for availability of postgresql driver.  32-bit driver , we noticed that there is no postgresql driver in the drivers list ( Name column values doesn't start with Postgres text). 64-bit driver , we noticed that there is no postgresql driver in the drivers list ( Name column values doesn't start with Postgres text).  Step2: Checking the current postgresql server version, to get the corresponding psqlodbc driver. As per below screen shot, current version is " 10.10 ". i will try to get and install psqlodbc of 10.10 version. Step3: When check the psqlodbc driver ( https://www.postgresql.org/ftp/odbc/versions/msi/ ), i have found the, psqlodbc_10_3 is the last version that was a...
Read more