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
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
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
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