From: | Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Dump schema without the functions |
Date: | 2008-02-01 13:44:22 |
Message-ID: | EAB364A0-A2B2-4802-AF6C-FED68BF2424E@grid.unep.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>> But I don't really get how the final command will look like.
>>
>> pg_restore -L <file_without_FUNCTIONS> -d <my_database>
>>
>> But somewhere I have to indicate the original file, no? I mean,
>> where do
>> all my data now come from? The original dump contains all data; the
>> newly created via
>>
>> pg_restore -l geodataportal.public | grep -v FUNCTION >
>> pgdump.geodataportal.public.no-func
>>
>> has only the TOC. But no data...
>
> Then you feed that file to pg_restore -L, along the original dump
> file.
I mean, that was exactly my question, how this would look like... Ok,
figured it out meanwhile:
pg_restore -L pgdump.geodataportal.public.no-func
-v pgdump.geodataportal.public
-U xxx
-d geodataportal
Thanks for your help!!
Stef
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Schwarzer | 2008-02-01 14:10:03 | Re: Forgot to dump old data before re-installing machine [solved] |
Previous Message | Alvaro Herrera | 2008-02-01 13:19:21 | Re: Dump schema without the functions |