Postgres Pro
Downloads
Home   >   mailing lists

how to dump functuions and views - Mailing list pgsql-admin

From juerg.rietmann@pup.ch
Subject how to dump functuions and views
Date
Msg-id OFBB40B044.37D31C01-ONC1256BCE.002E6CA9-C1256BCE.002EC8EF@pup.ch
Whole thread Raw
List pgsql-admin
Tree view 
Hello there

I use

pg_dump -t [table] [db] -s >  schemafile

and

pg_dump -t [table] [db]  >  datafile

to backup my database.

Is there a way/command to dump also the views and functions ?

Thank's in advance .... jr
__________________________________________________

PFISTER + PARTNER, SYSTEM - ENGINEERING AG
Juerg Rietmann
Grundstrasse 22a
6343 Rotkreuz
Switzerland

internet          :  www.pup.ch
phone       : +4141 790 4040
fax         : +4141 790 2545
mobile            : +4179 211 0315
__________________________________________________

pgsql-admin by date:

Previous
From: Tim Ellis
Date:
Subject: Re: multiple instances on one box?
Next
From: Jan Wieck
Date:
Subject: Re: [GENERAL] performance issues with DBI module when data too big