[GENERAL] find a free database design software

2006-09-09 Thread aBBISh
hello everyone: i want find a free software for design postgresql database model please commend one ~ thanks ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] how to add postgresql service by command on windows

2006-09-05 Thread aBBISh
Merlin Moncure 写道: On 9/5/06, aBBISh <[EMAIL PROTECTED]> wrote: hellow everyone, how to add postgresql service by command on windows? look at pg_ctl command. specifically, the 'register' option. merlin thank you ~ :) ---(

[GENERAL] how to add postgresql service by command on windows

2006-09-05 Thread aBBISh
hellow everyone, how to add postgresql service by command on windows? thanks. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your mes

[GENERAL] how to use variable for select query in pl/pgsql

2006-08-15 Thread aBBISh
hello everybody, i want use a variable to denote a table name in select query. for example: DECLARE table_message_data varchar; record_message_data record; BEGIN table_message_data := prefix || 'message_data'; select into record_message_data * from table_message_data

Re: [GENERAL] How to use the full text index feature on PostgreSQL

2006-08-10 Thread aBBISh
Chris 写道: aBBISh wrote: Hello everyone How to use the full text index feature to search a lot of text on PostgreSQL 8.x? You need to install & setup tsearch2. I have a small article about how to do that here: http://www.designmagick.com/article/27/ That article so good,thank you.

[GENERAL] How to use the full text index feature on PostgreSQL 8.x

2006-08-10 Thread aBBISh
Hello everyone How to use the full text index feature to search a lot of text on PostgreSQL 8.x? thank you~! ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq