Re: [GENERAL] PostgreSQL equivelant of this MySQL query

2007-07-15 Thread paddy carroll
select split_part(usr_email,'@',2) ||split_part(usr_email,'@',1) from .. Hi all, I am reading through some docs on switching to Postfix with a SQL backend. The docs use MySQL but I want to use PgSQL so I am trying to adapt as I go. I am stuck though; can anyone help give me the PgSQL

[GENERAL] smtp

2007-07-15 Thread paddy carroll
Can I have a straw poll on the best way to glue smtp to postgres, is exim the only option? Cheers ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's d

[GENERAL] SMTP

2007-07-16 Thread paddy carroll
Can I have a straw poll on the best way to glue smtp to postgres, is exim the only option? Cheers ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] SMTP

2007-07-16 Thread paddy carroll
store mail , send mail, receive mail, filter mail. I need a mail firewall for a set of bespoke applications in a secure environment. I will probably use postfix *+++ On 16 Jul 2007, at 17:54, Andrew Sullivan wrote: On Sun, Jul 15, 2007 at 08:53:54AM +0100, paddy carroll wrote: Can I have

Re: [GENERAL] tables not in list

2007-07-30 Thread paddy carroll
put all your tables in a new table (public.tables) select table_name from public.tables where public.tables.table_name not in (select table_name from information_schema.tables where table_catalog='postgres' and table_type='BASE TABLE' and table_schema='public') On 30 Jul 2007, at 20:31,