Re: pg_dump for domains

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rod Taylor <rbt(at)zort(dot)ca>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: pg_dump for domains
Date: 2002-04-05 11:41:59
Message-ID: 200204051141.g35Bfx710256@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


Patch applied. Thanks.

---------------------------------------------------------------------------

Rod Taylor wrote:
> 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.
>

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-04-05 11:52:47 Re: Rules on Views patch for psql
Previous Message Tatsuo Ishii 2002-04-05 06:24:53 PQescapeBytea is not multibyte aware