[GENERAL] Displaying a wide column with psql

2014-09-01 Thread Philip Rhoades
of using pg_dump, I couldn't see an interactive way of seeing the whole field. Is it possible? Thanks, Phil. -- Philip Rhoades GPO Box 3411 Sydney NSW 2001 Australia E-mail: p...@pricom.com.au -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Issue with CREATE EXTENSION tablefuncKreiter

2012-02-01 Thread Philip Rhoades
tgreSQL 8.x - there were old (unused) versions of LedgerSMB - during the move from Fedora 14 to Fedora 16 (x86_64), the data was dumped out of PG 8.x and restored to PG 9.1P I haven't done any manual messing around with template1 as far as I know . . Regards, Phil. -- Philip Rh

Re: [GENERAL] PostgreSQL for Firefox Bookmarks?

2009-08-13 Thread Philip Rhoades
Devrim, On 2009-08-14 00:55, Devrim GÜNDÜZ wrote: On Fri, 2009-08-14 at 00:20 +1000, Philip Rhoades wrote: It would be nice to be able to use PostgreSQL as the storage for Firefox Bookmarks - anyone know if this would be possible? how it could be done? Uh, I think it would consume more

[GENERAL] PostgreSQL for Firefox Bookmarks?

2009-08-13 Thread Philip Rhoades
People, It would be nice to be able to use PostgreSQL as the storage for Firefox Bookmarks - anyone know if this would be possible? how it could be done? Thanks, Phil. -- Philip Rhoades GPO Box 3411 Sydney NSW 2001 Australia E-mail: p...@pricom.com.au -- Sent via pgsql-general

Re: [GENERAL] Subselects - recursion problem

2005-05-30 Thread Philip Rhoades
Martijn, On Mon, 2005-05-30 at 21:08, Martijn van Oosterhout wrote: > On Mon, May 30, 2005 at 08:32:15PM +1000, Philip Rhoades wrote: > > Martijn, > > > > > > On Mon, 2005-05-30 at 19:50, Martijn van Oosterhout wrote: > > > "recursion problem&quo

Re: [GENERAL] Subselects - recursion problem

2005-05-30 Thread Philip Rhoades
Martijn, On Mon, 2005-05-30 at 19:50, Martijn van Oosterhout wrote: > On Mon, May 30, 2005 at 07:33:04PM +1000, Philip Rhoades wrote: > > People, > > > > The following script works (I have confirmed it by doing two separate > > views and doing a select on them) -

[GENERAL] Subselects - recursion problem

2005-05-30 Thread Philip Rhoades
t_diss = '0' AND c2.recon = 'N' AND c1.loc = c2.loc AND c1.lob = c2.lob AND c1.policy = c2.policy ) ORDER BY c1.loc, c1.lob, c1.policy ; -- Philip Rhoades Pricom Pty Limited (ACN 003 252 275 ABN 91 003 252