dumping the schema ?

Ask a Question related to PostgreSQL / PGSQL, Design and Development.

  1. #1

    Default dumping the schema ?

    hi,
    how can I dump the db schema so that I can recrate the DB later ?

    tia

    ---------------------------(end of broadcast)---------------------------
    TIP 6: Have you searched our list archives?

    [url]http://archives.postgresql.org[/url]

    raptor Guest

  2. Similar Questions and Discussions

    1. dumping roles
      Originally posted by: ianwinter Not as such. Why not? The data needs to be stored somewhere for IsUserInRole to read it, so why isn't there a...
    2. Dumping Scheduled Tasks
      Probably a little late now but maybe it will help someone else. The answer depends on your version of CF. If CF5 then they should be in the...
    3. dumping database
      sorry in addition to my last question, does anyone know if it's possible for a web service/site to "dump" out a snapshot of a subset of a...
    4. column dumping
      Hi, is there a smart command line ( Unix ) utility to dump out a particular column to the STDOUT/file from a file containing multi column data ?...
    5. Dumping values of all vars
      Hello, Is it possible to dump the values of all the vars in a perl script easily? I want to have a sub called Error that when called will tell me...
  3. #2

    Default Re: dumping the schema ?

    On Sat, 29 Jan 2005 21:55:23 +0200, raptor <raptor@tvskat.net> wrote:
    > hi,
    > how can I dump the db schema so that I can recrate the DB later ?

    From 'man pg_dump':
    -s

    --schema-only
    Dump only the schema (data definitions), no data.

    --
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~
    L. Friedman [email]netllama@gmail.com[/email]
    LlamaLand [url]http://netllama.linux-sxs.org[/url]

    ---------------------------(end of broadcast)---------------------------
    TIP 6: Have you searched our list archives?

    [url]http://archives.postgresql.org[/url]

    Lonni J Friedman Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

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 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139