Tag: create database

How to find the database creation date in PostgreSQL

In this article, we will see how to find the database creation date in PostgreSQL in windows and Linux.

There are two ways to check the database creation date in PostgreSQL. One is by running query against pg_database view and other is by checking PG_VERSION in base directory of specific database. Continue reading How to find the database creation date in PostgreSQL

Related Posts:

  1. How to create copy of existing database in PostgreSQL
  2. How to create database in Azure PostgreSQL Server
  3. How to rename PostgreSQL database
  4. How to switch role after connecting to database in PostgreSQL

How to create copy of existing database in PostgreSQL

In this article, we will see how to create copy of existing database in PostgreSQL.

Postgres allows the use of any existing database on the server as a template when creating a new database.

Syntax to create copy of PostgreSQL Database:
Continue reading How to create copy of existing database in PostgreSQL

Related Posts:

  1. Check the database size in PostgreSQL
  2. How to Copy table from one database to another in PostgreSQL
  3. How to export PostgreSQL data to csv or excel file
  4. How to take backup and restore a PostgreSQL Database