PostgreSQL Archives

How to Insert Current Date Time in PostgreSQL

Sometimes you may need to insert current date time in PostgreSQL. Here are the steps to do it.

Sometimes you may need to list most recent queries run in PostgreSQL. Here is how to show last queries executed in PostgreSQL.

Sometimes you may get PostgreSQL Error: Fatal role does not exist. Here is how to fix it.

Sometimes you may need to login to PostgreSQL without password. Here are the steps to do it.

Sometimes you may need to store PostgreSQL output to file. Here are the steps to do so.

Sometimes you may need to select every nth row from a PostgreSQL table. Here are the steps to do it.

Sometimes you may need to connect to PostgreSQL database via SSH tunnel in pgAdmin. Here are the steps to connect via SSH tunnel in pgAdmin.

Sometimes you may need to disable triggers in PostgreSQL. Here are the steps to do so.

Sometimes you may need to create views in PostgreSQL. Here is how to manage PostgreSQL views.

Database administrators need to backup & restore PostgreSQL databases. Here are the steps to backup & restore PostgreSQL database.