SUMMARY mysql -> psql

This is what I finally ended up with, thanks to those who helped get me here.




--
-- PostgreSQL database dump
--  pg_dump -d -c -s dbname
--

\connect - username

SET search_path = public, pg_catalog;

ALTER TABLE ONLY public.inbound DROP CONSTRAINT inbound_pkey;
ALTER TABLE ONLY public.outbound DROP CONSTRAINT id;
DROP TABLE public.inbound;
DROP TABLE public.outbound;
DROP SEQUENCE public.serial8;
DROP SEQUENCE public.serial;
DROP TABLE public.ports;
--
-- TOC entry 4 (OID 119511)
-- Name: ports; Type: TABLE; Schema: public; Owner: username
--

CREATE TABLE ports (
    port integer DEFAULT 0 NOT NULL,
    protocol text DEFAULT 'tcp' NOT NULL,
    service character(50) DEFAULT '' NOT NULL,
    description character(100) DEFAULT ''
);


--
-- TOC entry 2 (OID 119520)
-- Name: serial; Type: SEQUENCE; Schema: public; Owner: username
--

CREATE SEQUENCE serial
    START 1
    INCREMENT 1
    MAXVALUE 9223372036854775807
    MINVALUE 1
    CACHE 1;


--
-- TOC entry 3 (OID 119522)
-- Name: serial8; Type: SEQUENCE; Schema: public; Owner: username
--

CREATE SEQUENCE serial8
    START 1
    INCREMENT 1
    MAXVALUE 9223372036854775807
    MINVALUE 1
    CACHE 1;


--
-- TOC entry 5 (OID 119536)
-- Name: outbound; Type: TABLE; Schema: public; Owner: username
--

CREATE TABLE outbound (
    source character(100) DEFAULT '',
    destination character(100) DEFAULT '',
    sport integer DEFAULT 0 NOT NULL,
    dport integer DEFAULT 0 NOT NULL,
    "time" timestamp without time zone DEFAULT now() NOT NULL,
    id bigint DEFAULT nextval('serial'::text) NOT NULL
);


--
-- TOC entry 6 (OID 119554)
-- Name: inbound; Type: TABLE; Schema: public; Owner: username
--

CREATE TABLE inbound (
    source character(100) DEFAULT '',
    destination character(100) DEFAULT '',
    sport integer DEFAULT 0 NOT NULL,
    dport integer DEFAULT 0 NOT NULL,
    "time" timestamp without time zone DEFAULT now() NOT NULL,
    id bigint DEFAULT nextval('serial'::text) NOT NULL
);


--
-- TOC entry 7 (OID 119544)
-- Name: id; Type: CONSTRAINT; Schema: public; Owner: username
--

ALTER TABLE ONLY outbound
    ADD CONSTRAINT id PRIMARY KEY (id);


--
-- TOC entry 8 (OID 119562)
-- Name: inbound_pkey; Type: CONSTRAINT; Schema: public; Owner: username
--

ALTER TABLE ONLY inbound
    ADD CONSTRAINT inbound_pkey PRIMARY KEY (id);