-
Notifications
You must be signed in to change notification settings - Fork 1.5k
/
V002__create_copy_test_table.sql
64 lines (50 loc) · 1.46 KB
/
V002__create_copy_test_table.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
--
-- Copyright 2010-2014 Axel Fontaine
--
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
-- http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
--
--
-- 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;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: copy_test; Type: TABLE; Schema: public; Owner: arnd; Tablespace:
--
CREATE TABLE copy_test (
c1 integer NOT NULL,
c2 character varying,
c3 double precision
);
--
-- Name: copy_test_c1_seq; Type: SEQUENCE; Schema: public; Owner: arnd
--
CREATE SEQUENCE copy_test_c1_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: c1; Type: DEFAULT; Schema: public; Owner: arnd
--
ALTER TABLE ONLY copy_test ALTER COLUMN c1 SET DEFAULT nextval('copy_test_c1_seq'::regclass);
--
-- PostgreSQL database dump complete
--