Re: scripts in Postgres
От | Craig Bryden |
---|---|
Тема | Re: scripts in Postgres |
Дата | |
Msg-id | 000d01c54f0f$4afc7550$0200a8c0@amd2800 обсуждение исходный текст |
Ответ на | scripts in Postgres ("Craig Bryden" <postgresql@bryden.co.za>) |
Ответы |
Re: scripts in Postgres
(Tino Wildenhain <tino@wildenhain.de>)
|
Список | pgsql-general |
Hi Thanks for the reply. Since I don't intend using any of the interfaces at the moment, How would I write the script below in SQL then. Please keep in mind that I will be sending this script to other people to run and that it needs to be totally automated. Thanks Craig ----- Original Message ----- From: "Sean Davis" <sdavis2@mail.nih.gov> To: "Craig Bryden" <postgresql@bryden.co.za>; "pgsql" <pgsql-general@postgresql.org> Sent: Monday, May 02, 2005 1:57 PM Subject: Re: [GENERAL] scripts in Postgres > Yes, pl/pgsql needs to be written as a function. If you want to "script" > things, that is done in SQL or via one of the interfaces for perl, python, > java, etc. You can just do the DROP TABLE, ignore the error message if the > table doesn't exist, and then create the table. The documenation is quite > good, so check out: > > http://www.postgresql.org/docs/8.0/interactive/server-programming.html > > for many examples. > > Sean > > ----- Original Message ----- > From: "Craig Bryden" <postgresql@bryden.co.za> > To: "pgsql" <pgsql-general@postgresql.org> > Sent: Monday, May 02, 2005 7:21 AM > Subject: [GENERAL] scripts in Postgres > > > > Hi > > > > I am fairly new to Postgres and am struggling to understand one concept. > > If > > I wish to use pl/pgsql, must it be in a function? > > An example of where I would not want it to be in a function is: > > > > I have a CREATE TABLE statement that I want to execute. But the script > > must > > first check for the existence of the table. I wrote the following code, > > but > > it errors on the first word (IF). Please tell me how to do this: > > > > > > IF EXISTS (SELECT * FROM information_schema.tables WHERE table_Name = > > 'tb_Messages') > > DROP TABLE tb_Messages; > > > > CREATE TABLE tb_Messages ( > > MessageID bigserial PRIMARY KEY, > > From varchar(255), > > To varchar(255), > > DateSent timestamp not null DEFAULT current_timestamp, > > Subject varchar(255) NULL, > > MessageBody Text null, > > IsRead smallint default 0, > > DeleteFlag smallint default 0, > > AdditionalInfo int NULL, > > ReplyToMessage bigint NULL > > > > ) WITHOUT OIDS; > > > > Thanks > > Craig > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/docs/faq > > > > > >
В списке pgsql-general по дате отправления: