How To Create Table In PostgreSQL Using pgAdmin And SQL Shell psql || Po...

Only 3.9% of viewers are subscribing to my channel 😓.

I request you to please give click on Subscribe button.

It really helps me grow 😢.

-- Table: public.employees

-- DROP TABLE IF EXISTS public.employees;

CREATE TABLE IF NOT EXISTS public.employees

(

    empid bigint NOT NULL,

    salary real NOT NULL DEFAULT 100,

    name character varying(50) COLLATE pg_catalog."default" NOT NULL,

    deptno bigint DEFAULT 1,

    gender character varying(15) COLLATE pg_catalog."default" DEFAULT 'Female'::character varying,

    CONSTRAINT emp_pk PRIMARY KEY (empid)

)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.employees

    OWNER to postgres;

COMMENT ON TABLE public.employees

    IS 'This table will contain data for employees';

how to create table in postgresql using pgadmin and sql shell psql

how to create table in postgresql

how to create table in postgresql using sql shell psql

create table in postgresql using pgadmin and sql shell psql

create table in postgresql

create table in postgresql using sql shell psql

table in postgresql, pgadmin,sql,shell,psql,sql shell psql,postgres,postgresql tutorials,postgresql

knowledge 360,akram sohail

How To Create Table In PostgreSQL Using pgAdmin And SQL Shell psql, PostgreSQL Tutorials