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
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 |