pg_dump for domains 
Author Message
 pg_dump for domains

Your patch has been added to the PostgreSQL unapplied patches list at:

        http://www.***.com/

I will try to apply it within the next 48 hours.

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

Quote:

> 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... ]

Quote:

> ---------------------------(end of broadcast)---------------------------


--
  Bruce Momjian                        |   http://www.***.com/

  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Mon, 20 Sep 2004 14:37:34 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. pg_dump for domains

2. pgsql/src/bin/pg_dump pg_dump.c pg_dump.h

3. pgsql/src/bin/pg_dump pg_dump.c pg_dump.h

4. pgsql-server/src/bin/pg_dump pg_dump.c pg_dump ...

5. pgsql/src/bin/pg_dump (pg_dump.c pg_dump.h)

6. pgsql/src/bin/pg_dump common.c pg_dump.c pg_dump.h

7. pgsql/src/bin/pg_dump (common.c pg_backup_archiver.h pg_dump.c pg_dump.h)

8. pgsql/src/bin/pg_dump pg_dump.c pg_dump.h

9. pgsql/src/bin/pg_dump (pg_dump.c pg_dump.h pg_dumpall.sh)

10. pgsql/src/bin/pg_dump pg_dump.c pg_dump.h

11. pgsql-server/src/bin/pg_dump pg_dump.c pg_dump.h

12. pgsql-server/src/bin/pg_dump pg_dump.c pg_dump ...


 
Powered by phpBB® Forum Software