how to dump functuions and views

From: juerg(dot)rietmann(at)pup(dot)ch
To: pgsql-admin(at)postgresql(dot)org
Subject: how to dump functuions and views
Date: 2002-06-04 08:30:24
Message-ID: OFBB40B044.37D31C01-ONC1256BCE.002E6CA9-C1256BCE.002EC8EF@pup.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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
__________________________________________________

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tao Wan 2002-06-04 16:27:32 help to unsubscribe, please
Previous Message Tim Ellis 2002-06-03 23:53:37 Re: multiple instances on one box?