Re: [SQL] Query response time

2006-08-09 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2006-08-08 13:25:47 +0100: > I am using PostgresSQL 7.4 and having some serious performance issues. > I am using tables that only contain approx 2GB of data. > The install was performed by yum onto a RAID server using Centos. I am > sure there is something fundamentally wron

Re: [SQL] Change of data type

2006-08-08 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2006-08-07 12:38:20 -0500: >Hello everybody, excuse me how can I change de data type of a field, > I currently have: > >material character(30) > >but I now want the field in text type like this: > >material text > >somebody knows if ALTER TABLE h

Re: [SQL] [GENERAL] How do I copy part of table from db1 to db2 (and rename the columns)?

2005-09-05 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2005-08-31 12:00:30 +0200: > I want to copy several columns of a source table from db1 to db2, and > create the target table and rename the columns in the process. > > Is that possible in PostgresQL? If so, an example or url for such a > command /script would be appreciated.