[GENERAL] importing dates

2008-08-28 Thread thefronny
I need to copy some data that includes an date as /MM/DD. Is there a method I can do this and replace the "/" with "-" on the fly in the copy command string? thx, tf -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgr

Re: [GENERAL] type casting in 8.3

2008-02-11 Thread thefronny
On Feb 11, 3:15 am, "${spencer}" <[EMAIL PROTECTED]> wrote: > I just literally ran my first search of the day and got the same > error. > > i changed my query so that the integer was cast into text and then it > worked fine. > > [EMAIL PROTECTED] wrote: > > All, > > > I'm getting the following (new

[GENERAL] Selecting all but a few fields in a query

2007-11-06 Thread thefronny
I have a table with a lot of fields, some of which are type TEXT. I seem to have a lot of occasions where I'd like to see almost all of the fields in a query but a SELECT * will pull in the text fields, which then wrap across the screen, even using \x. Is there a variation of SELECT that is somethi

Re: [GENERAL] Solaris Postgresql 8.1.8 vs Postgresql 8.2.4

2007-05-10 Thread thefronny
On May 9, 4:56 am, [EMAIL PROTECTED] (Simon Smith) wrote: > I am planning to set up a new solaris 10 sparc server with a postgresql > database. > > It looks like solaris 10 comes with version 8.1.8 of postgres. > > Is there any benefit in using the 8.1.8 included solaris version over the > curren