Yan Cheng Cheok wrote:
I try to have the following stored procedure, to help me create tables, if the
table does not exists (Is this a good practice by the way?)
if not exists(select * from information_schema.tables where table_name =
'MYTABLE') then
RAISE NOTICE 'table not there yet.';
CRE
I try to have the following stored procedure, to help me create tables, if the
table does not exists (Is this a good practice by the way?)
if not exists(select * from information_schema.tables where table_name =
'MYTABLE') then
RAISE NOTICE 'table not there yet.';
CREATE TABLE MYTABLE
(
"va