pg_dump for domains

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема pg_dump for domains
Дата
Msg-id 09d701c1d5f3$8365a350$8001a8c0@jester
обсуждение исходный текст
Ответы Re: pg_dump for domains  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Re: pg_dump for domains  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: pg_dump for domains  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-patches
Adds domain dumping support to pg_dump.

Is the use of deps proper or necessary?


Tested with the below:


--
-- Selected TOC Entries:
--
\connect - rbt

--
-- TOC Entry ID 2 (OID 16582)
--
-- Name: dom1 Type: DOMAIN Owner: rbt
--

CREATE DOMAIN "dom1" AS integer NOT NULL;

--
-- TOC Entry ID 4 (OID 16583)
--
-- Name: dom2 Type: DOMAIN Owner: rbt
--

CREATE DOMAIN "dom2" AS text DEFAULT 'haha';

--
-- TOC Entry ID 5 (OID 16584)
--
-- Name: dom3 Type: DOMAIN Owner: rbt
--

CREATE DOMAIN "dom3" AS integer NOT NULL DEFAULT 4;

--
-- TOC Entry ID 6 (OID 16585)
--
-- Name: tab1 Type: TABLE Owner: rbt
--

CREATE TABLE "tab1" (
        "col1" dom1 NOT NULL,
        "col2" dom2,
        "col3" dom3 NOT NULL,
        "col4" dom1 DEFAULT 1 NOT NULL,
        "col5" dom2 DEFAULT 'different' NOT NULL
);

--
-- Data for TOC Entry ID 7 (OID 16585)
--
-- Name: tab1 Type: TABLE DATA Owner: rbt
--


COPY "tab1" FROM stdin;
1       haha    4       1       different
\.
--
-- TOC Entry ID 3 (OID 16582)
--
-- Name: DOMAIN "dom1" Type: COMMENT Owner:
--

COMMENT ON DOMAIN "dom1" IS 'HEHE';
--
Rod Taylor

Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. Close your eyes. The
opinions stated above are yours. You cannot imagine why you ever felt
otherwise.


Вложения

В списке pgsql-patches по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [JDBC] little error messages fix
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: ALT*R T*BL* S*T / DR*P N*T N*LL patch - 4th try