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 get primary key of newly inserted row 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 need to reset primary sequence in PostgreSQL. Here are the steps to do so.

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 get row count for all tables in PostgreSQL. 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 insert text with single quotes in PostgreSQL. Here are the steps to do it.