Wednesday 6 March 2024

How To Create A Database In PostgreSQL 16 Using pgAdmin 4 Or psql SQL Sh...






CREATE DATABASE "Akram_DB"
    WITH
    OWNER = postgres
    ENCODING = 'UTF8'
    LC_COLLATE = 'English_United States.1252'
    LC_CTYPE = 'English_United States.1252'
    LOCALE_PROVIDER = 'libc'
    TABLESPACE = pg_default
    CONNECTION LIMIT = -1
    IS_TEMPLATE = False;

COMMENT ON DATABASE "Akram_DB"
    IS 'This is a demo database';
Create table TestDemo(id numeric, name character varying(50) not null);

select version();
CREATE DATABASE testdemo2_db
    WITH
    OWNER = postgres
    ENCODING = 'UTF8'
    LC_COLLATE = 'English_United States.1252'
    LC_CTYPE = 'English_United States.1252'
    LOCALE_PROVIDER = 'libc'
    TABLESPACE = pg_default
    CONNECTION LIMIT = -1
    IS_TEMPLATE = False;

How To Create A Database In PostgreSQL 16,Using pgAdmin 4 Or psql SQL Shell,How To Create A Database,In PostgreSQL,Using pgAdmin 4,psql SQL Shell,Create A Database In PostgreSQL,Database In PostgreSQL Using pgAdmin 4,Database In PostgreSQL Using psql SQL Shell,How To,Create A Database In PostgreSQL 16,pgAdmin,psql,SQL Shell,Database,create,how to create database,create postgres database,database postgres,new database postgres,postgresql new database create,pgadmin create database,pgadmin database,psql database

No comments:

Post a Comment