How To Upgrade PGAdmin on Windows
There is not an auto upgarde button built into pgadmin so the latest and greatest will need to be downloaded from the pgadmin site here.
Shell Script To Check Number Of Rows In A PostgreSQL Database
The below code snipet was created to check the number of rows in a PostgreSQL database, log the output to a file, and warn if the number of rows is over a certain number. There are numerous variables in the code snipet below that will need to be modified for it to work properly including…
How To See The Number Of Rows In A PostgreSQL Table
Checking the number of rows in a PostgreSQL table is very easy. First connect to the database by using pgsql. psql -U postgres -d “database-name” Next use the following command to see the number of rows in a certain table. select count(*) from tablename
Timestamp support for Rails and MySQL/PostgreSQL/Oracle
Troel has written a great summary of the SQL standard for the timestamp data type along with its implementation in the big 5 databases (MySQL, PostgreSQL, Microsoft SQL Server, Oracle, and DB2). MySQL It turns out that MySQL does not support sub-second time or date formats. There is a MICROSECOND function in MySQL allowed to…
Settings for Creating a New Database in PostgreSQL
I wanted to quickly create a new database via pgAdmin III, so I used the following properties Note: initdb (which ran during step 6 of the installation process) creates two initial databases, namely postgres and template1. Also, the cluster created by initdb also comes with two templates (template0 and template1). template0 is a backup for…