Membuat dan menambahkan tabel

-- Mengatur parameter
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', 'public', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

-- Membuat tabel
CREATE TABLE public.Buah (
    namaBuah CHARACTER(20),
    Jumlah CHARACTER(20),
    Harga CHARACTER(20)
);

-- Memasukkan data ke dalam tabel
INSERT INTO public.Buah (namaBuah, Jumlah, Harga) VALUES
('Mangis', '21', '2000'),
('Mangga', '24', '1500'),
('Rambutan', '23', '3500'),
('Bengkoang', '22', '4500'),
('Apel', '30', '3000'),
('Jeruk', '28', '2500'),
('Pisang', '40', '1500'),
('Durian', '10', '10000'),
('Semangka', '15', '5000'),
('Melon', '16', '5500'),
('Pepaya', '25', '2000'),
('Nanas', '20', '2500'),
('Anggur', '18', '8000'),
('Lemon', '30', '3000'),
('Alpukat', '22', '6000'),
('Belimbing', '35', '2000'),
('Ceri', '40', '7000'),
('Duku', '38', '3500'),
('Guava', '32', '3000'),
('Jambu Air', '36', '2500');