Skip to content
Question Defense
Technical answers for technical questions
Question Defense
  • Backtrack Linux
    • Backtrack Article Request
  • HTTP ERROR
  • Kali Linux
    • Kali Linux Article Request
  • Privacy Policy
  • Tools
    • Class Of Device – Bluetooth CoD List In Binary And Hex
    • phpMyAdmin Blowfish Secret Generator
  • Documentation
    • check_postgres.pl
    • Linux Man Pages
      • insmod
      • kill
      • Logrotate
      • ls
      • lsmod
      • mail
      • modprobe
      • more
      • mysqldump
      • ntfsprogs
      • ntfsresize
      • pg_dump
      • psql
      • rmmod
      • screen
    • Monarch
      • Monarch Commands
      • Monarch Control
      • Monarch Escalations
      • Monarch Groups
      • Monarch Management of Nagios Hosts
      • Monarch Managing Nagios Contacts
      • Monarch Managing Nagios Hosts
      • Monarch Profiles
      • Monarch Services Template
      • Monarch Time Periods
      • Monarch Tools
  • Tags
  • Contact
Linkedin page opens in new windowTwitter page opens in new window
Search:
Search
  • Backtrack Linux
    • Backtrack Article Request
  • HTTP ERROR
  • Kali Linux
    • Kali Linux Article Request
  • Privacy Policy
  • Tools
    • Class Of Device – Bluetooth CoD List In Binary And Hex
    • phpMyAdmin Blowfish Secret Generator
  • Documentation
    • check_postgres.pl
    • Linux Man Pages
      • insmod
      • kill
      • Logrotate
      • ls
      • lsmod
      • mail
      • modprobe
      • more
      • mysqldump
      • ntfsprogs
      • ntfsresize
      • pg_dump
      • psql
      • rmmod
      • screen
    • Monarch
      • Monarch Commands
      • Monarch Control
      • Monarch Escalations
      • Monarch Groups
      • Monarch Management of Nagios Hosts
      • Monarch Managing Nagios Contacts
      • Monarch Managing Nagios Hosts
      • Monarch Profiles
      • Monarch Services Template
      • Monarch Time Periods
      • Monarch Tools
  • Tags
  • Contact

Tag Archives: postgres

You are here:
  1. Home
  2. Entries tagged with "postgres"

Technology Insights

How To Upgrade PGAdmin on Windows

InsightsBy alexSeptember 2, 20081 Comment

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.

Code Snippets

Shell Script To Check Number Of Rows In A PostgreSQL Database

Code SnippetsBy alexAugust 23, 2008Leave a comment

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…

Technology Insights

How To See The Number Of Rows In A PostgreSQL Table

InsightsBy alexAugust 21, 2008Leave a comment

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

Technology Insights

Timestamp support for Rails and MySQL/PostgreSQL/Oracle

InsightsBy Chirag PatelAugust 13, 2008Leave a comment

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…

Technology Insights

Settings for Creating a New Database in PostgreSQL

InsightsBy Chirag PatelAugust 10, 20082 Comments

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…

1
2
…34567
Question Defense
© 2021 question-defense.com
Go to Top