[SQL] SCHEMA's

2003-03-03 Thread Hepworth, Mike
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

Re: [SQL] [pgadmin-support] hi

2002-10-18 Thread Hepworth, Mike
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,