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:07:32 |
Message-ID: | E29676A3-2541-4BA6-9EE4-85F09844CE2E@grid.unep.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>>>> how can I dump a schema with all tables, but without the functions?
>>>
>>> There's no built-in single command for that. You can accomplish
>>> it by
>>> using pg_restore -l to make a list of objects, then edit the list,
>>> then pg_restore -L to restore only the objects in the edited list.
>> Hmmm.. I probably should have mentioned that it's not a "normal"
>> dump, but one including imported shapefiles. So my dump comes from
>> this:
>> pg_dump -Fc ...
>> and - sorry, myself not being an expert - it seems to me that this
>> file is not editable anymore.
>
> No, but if you run pg_restore -l <my_dump_file> that will output a
> list of objects that IS editable. Then pg_restore -L ... will only
> restore the items in that list.
Ah, ok. Right, I can see that.
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...
Thanks for any advice.
Stef
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-02-01 13:19:21 | Re: Dump schema without the functions |
Previous Message | Rubén Rubio | 2008-02-01 12:39:17 | Log query statistics |