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);