Thread: how to dump functuions and views

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
__________________________________________________

Hi, all,

Sorry to clutter your mailbox. I try to unsubscribe from this mail list,
but always failed. Could you please tell me how to unsubscribe? Thanks.

Tony

Send a mail to majordomo@postgresql.org and put that in the body :

approve yourpass unsubscribe pgsql-admin yourmail@something.com

Best regards,
Vergoz Michael

----- Original Message -----
From: "Tao Wan" <tawan@cs.nmsu.edu>
Cc: <pgsql-admin@postgresql.org>
Sent: Tuesday, June 04, 2002 6:27 PM
Subject: [ADMIN] help to unsubscribe, please


> Hi, all,
>
> Sorry to clutter your mailbox. I try to unsubscribe from this mail list,
> but always failed. Could you please tell me how to unsubscribe? Thanks.
>
> Tony
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org