Hello... Is it possible in PostGre 7.3 to query the size of a text[] array attribute of a table? Does anyone know how this is queried in 7.3?
thanks... help is greatly needed. eddie ----- Original Message ----- From: "Po Eddie Lim" <[EMAIL PROTECTED]> To: "Mike Nolan" <[EMAIL PROTECTED]>; "Paul Tillotson" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, September 03, 2004 4:12 PM Subject: Re: [GENERAL] postgres "on in the internet" > Hello... > > Is it possible in PostGre 7.3 to query the size of a text[] array attribute > of a table? Does anyone know how this is queried in 7.3? > > thanks... help is greatly needed. > eddie > > ----- Original Message ----- > From: "Mike Nolan" <[EMAIL PROTECTED]> > To: "Paul Tillotson" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Friday, September 03, 2004 8:42 AM > Subject: Re: [GENERAL] postgres "on in the internet" > > > > > Does anyone out there have experience with this or recommended best > > > practices? We have been looking at either (a) tunnelling everything > > > over ssh, or (b) just making sure that users have "strong" passwords and > > > requiring "md5" authentication in pg_hba.conf. > > > > Have you considered using VPN routers to punch a hole through your > firewall? > > > > Can you do a a combination of A and B? (Does that make much sense?) > > > > You should also consider blocking all IP addresses other than the client > > nodes at the firewall. That won't help much if the client node gets > > compromised. > > -- > > Mike Nolan > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to [EMAIL PROTECTED] so that your > > message can get through to the mailing list cleanly > > > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html