Create a table & insert records using Arrays in PostgreSQL

create_insert_postgresql_array.sql

create table sal_emp (
    name            text,
    pay_by_quarter  integer[],
    schedule        text[][]
);

insert into sal_emp
    values ('Bill',
    '{10000, 10000, 10000, 10000}',
    '{{"meeting", "lunch"}, {"training", "presentation"}}');

insert into sal_emp
    values ('Carol',
    '{20000, 25000, 25000, 25000}',
    '{{"breakfast", "consulting"}, {"meeting", "lunch"}}');

insert into sal_emp
    values ('Sean',
    ARRAY[2000, 15000, 20000, 10000],
    ARRAY[['meeting', 'lunch'], ['training', 'presentation']]);

insert into sal_emp
    values ('Penn',
    ARRAY[20000, 25000, 10000, 25000],
    ARRAY[['breakfast', 'consulting'], ['meeting', 'lunch']]);