But I don't really get how the final command will look like.
pg_restore -L -d
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
Stefan Schwarzer wrote:
> But I don't really get how the final command will look like.
>
> pg_restore -L -d
>
> 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_resto
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 sh
Stefan Schwarzer wrote:
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
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 sho
Stefan Schwarzer <[EMAIL PROTECTED]> writes:
> 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 object
> how can I dump a schema with all tables, but without the functions? Is
> there a way to do it, or do I have to manually drop the functions
> later when having used the pg_restore?
Stef,
You can edit the data between dump and restore, to comment out the
function references. Or, you can use the "-
Hi there,
how can I dump a schema with all tables, but without the functions? Is
there a way to do it, or do I have to manually drop the functions
later when having used the pg_restore?
Thanks for any advice,
Stef
smime.p7s
Description: S/MIME cryptographic signature
