pg_dump question

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: PostgreSQL general list <pgsql-general(at)postgresql(dot)org>
Subject: pg_dump question
Date: 2002-01-24 00:02:35
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB0452DDAF@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Howdy:

(okay, last question for today)

I have a few views that were created. The views use have
special functions that I need. Example:

[snip]

drop view t_bp_disease;
drop view v_bp_disease;
create view v_bp_disease as
select
lpad (bp_disease_id::text,10,'0') as bp_disease_id,
rpad (bp_dis_label::text,30,' ') as bp_dis_label
from bp_disease

[/snip]

Works fine. Now I want to use pg_dump to put this into a
plain ascii file. I'm trying a few combinations of pg_dump,
but I don't get anything but schema or and empty file.
For example, if I use something like:

pg_dump -u -t test.view -d database > outfile

I get errors. The man page says t = table ONLY.

My question: Can I get a dump of the view as it appears
with the modifications and NOT of the table it originated
from?

Thanks!

-X

Browse pgsql-general by date

  From Date Subject
Next Message Command Prompt, Inc. 2002-01-24 01:08:14 pgManage (GUI PostgreSQL front end)
Previous Message Johnson, Shaunn 2002-01-23 23:53:12 Re: pad column with leading zeros or space