Skip site navigation (1) Skip section navigation (2)

Re: pg_dump for domains

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Rod Taylor" <rbt(at)zort(dot)ca>, <pgsql-patches(at)postgresql(dot)org>
Subject: Re: pg_dump for domains
Date: 2002-03-28 01:37:25
Message-ID: GNELIHDDFBOCMGBFGEFOMEOGCBAA.chriskl@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-patches
One nice thing about the way this dump works is that if the implementation
details are changed at a later date (as Tom has suggested) then older dumps
will still work without any trouble - unlike foreign keys!

Chris

> -----Original Message-----
> From: pgsql-patches-owner(at)postgresql(dot)org
> [mailto:pgsql-patches-owner(at)postgresql(dot)org]On Behalf Of Rod Taylor
> Sent: Thursday, 28 March 2002 8:57 AM
> To: pgsql-patches(at)postgresql(dot)org
> Subject: [PATCHES] pg_dump for domains
>
>
> 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.
>
>


In response to

pgsql-patches by date

Next:From: ...PaulDate: 2002-03-28 19:13:09
Subject: Rules on Views patch for psql
Previous:From: Christopher Kings-LynneDate: 2002-03-28 01:29:27
Subject: ALT*R T*BL* S*T / DR*P N*T N*LL patch - 4th try

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group