Yes, they are in template1.
This then begs the question, why are they not in the hmzbook database?
All the tables were added via psql -f /tmp/dump.hmzbook which has one
connect line in it. \connect hmzbook xxxx.
David
Thomas Lockhart wrote:
>...
>
>
>>What the heck just happened and short of dumping these tables out and
>>importing them back into the other database...
>>
>>
>
>Most likely, you accidentally added the tables to template1, which then
>propagates to any new databases added after that.
>
>Clean up template1, then clean up your existing databases, and you
>should be back to normal for any new ones. dump/reload is not required,
>except to get tables into databases which need them.
>
> - Thomas
>
>