Need some help with schema's.
I want to be able make a user have a default schema other than public.
I want to be able to have several schema's with the same group of tables
define in each one.
(Example)
schema a (users 1,2,3)
table a
table b
table c
schema b (users 4,5,6
lz,
You
could use the plpgsql function language and create a function that tests for the
existence of the file and drop it if it does.
Something like this:
select
dropTableIfExists('test');
The
dropTableIfExists would be the plpgsql function that you would need to
write.
Later,