Top Open Source IP Address Management Software

In this post you will find top open source software for IP address management (IPAM). If you are sysadmin at organization that holds pool of IP addresses and allocates its parts to clients then you must use IP address management tools to track used, reserved, allocated or free IP addresses. It usually prevents an overhead and allows to have clear picture of IP addresses resources usage within an organization on the […]

Read more →

 

PostgreSQL to File

PostgreSQL (or simply Postgres) is powerful and extremely popular database management system. It comes with easy to use tool that makes it possible to export output of any query into text file. If you are familiar with Mysql you may know about SELECT … INTO OUTFILE syntax already so here is its equivalent to output PostgreSQL to file: 1. Connect to PostgreSQL DBA: $ psql -U postgres -p 5432 databasename […]

Read more →

 

Postgresql: show tables, show databases, show columns, describe table

PostgreSQL is one of the best database engines for an average web project and many who moves to psql from mysql (for example) often ask the following questions: what  is the analog of “show tables” in postgres? or how can I get the list of databases in postgres like “show databases” in mysql? The answers are short: mysql: SHOW TABLES postgresql: \d postgresql: SELECT table_name FROM information_schema.tables WHERE table_schema = […]

Read more →