In this article, we will see how to create database in Azure PostgreSQL Server.
Database is collection objects like tables, views, indexes, schemas, ….etc.
We are going to create a database in Azure PostgreSQL server by using following two methods.
1. Using CREATE DATABASE command.
2. Using GUI method using pgadmin tool.
Continue reading How to create database in Azure PostgreSQL Server
In this article, we will see how to create user in Azure PostgreSQL server.
We are going to create user in Azure MySQL server by using two ways.
1. Using GUI methods.
2. Using Create user statement on psql tool or pgadmin tool.
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
In this article, we are going to see how to Create PostgreSQL table structure from existing table with examples.
PostgreSQL query to copy the structure of an existing table to create another table.
create table table_name as select * from exsting_table_name where 1=2;
Continue reading PostgreSQL Create table from existing table
