Postgresql pg_dump, doesnt work well on dumping and restore schema

Question

dear comrades,

I use code belows for dump a specific schema, before dumped it has 4 views on those schema.

# pg_dump -U username -h host -n schema_name > some_schema.dump

Then I restore it with psql tools

# \i /path/to/mydump/some_schema.dump

After psql finish his restore process , i just only got 3 views, i have no idea where the 1 views go. i use postgresql 8.3 on ubuntu karmic.

Thanks in advance for any answer. -regards-

Answer 1

Are you sure it has 4 views? Or is it that your search_path is set to this schema as well, but the view is actualy in another schema?

SELECT * FROM pg_views WHERE schemaname = 'your_schemaname';