Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mrbx:TWSTrader h4rr$ /Library/PostgreSQL/9.1/bin/pg_dump --username=postgres --password --host=localhost trifecta | head -n 100Password:
- --
- -- PostgreSQL database dump
- --
- SET statement_timeout = 0;
- SET client_encoding = 'UTF8';
- SET standard_conforming_strings = ON;
- SET check_function_bodies = FALSE;
- SET client_min_messages = warning;
- --
- -- Name: trifecta; Type: COMMENT; Schema: -; Owner: trifecta
- --
- COMMENT ON DATABASE trifecta IS 'Trifecta database';
- --
- -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
- --
- CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
- --
- -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
- --
- COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
- SET search_path = public, pg_catalog;
- SET default_tablespace = '';
- SET default_with_oids = FALSE;
- --
- -- Name: historical_data; Type: TABLE; Schema: public; Owner: trifecta; Tablespace:
- --
- CREATE TABLE historical_data (
- id INTEGER NOT NULL,
- stock_id INTEGER NOT NULL,
- DATE DATE,
- OPEN DOUBLE PRECISION,
- high DOUBLE PRECISION,
- low DOUBLE PRECISION,
- close DOUBLE PRECISION,
- volume BIGINT,
- adj_close DOUBLE PRECISION,
- adj_open DOUBLE PRECISION,
- adj_high DOUBLE PRECISION,
- adj_low DOUBLE PRECISION
- );
- ALTER TABLE public.historical_data OWNER TO trifecta;
- --
- -- Name: historical_data_id_seq; Type: SEQUENCE; Schema: public; Owner: trifecta
- --
- CREATE SEQUENCE historical_data_id_seq
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.historical_data_id_seq OWNER TO trifecta;
- --
- -- Name: historical_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: trifecta
- --
- ALTER SEQUENCE historical_data_id_seq OWNED BY historical_data.id;
- --
- -- Name: historical_data_id_seq; Type: SEQUENCE SET; Schema: public; Owner: trifecta
- --
- SELECT pg_catalog.SETVAL('historical_data_id_seq', 679164, TRUE);
- --
- -- Name: stock_info; Type: TABLE; Schema: public; Owner: trifecta; Tablespace:
- --
- CREATE TABLE stock_info (
- id INTEGER NOT NULL,
- symbol CHARACTER VARYING(25),
- market CHARACTER VARYING(10),
- url CHARACTER VARYING
- );
- ALTER TABLE public.stock_info OWNER TO trifecta;
Add Comment
Please, Sign In to add comment