Re: [SQL] problem converting strings to timestamps with time zone

Could you please post the exact string how you did? Thanks Deepak On Thu, Apr 29, 2010 at 12:59 AM, Edward Ross wrote: > Tom Lane wrote: > >> Edward Ross writes: >> >>> Here is a sandbox example of what I mean. >>> >> >> CREATE TABLE test_0 >>> ( >>>string_value varchar(2047), >>>time

[SQL] pg_restore error - Any Idea?

Hi All, I am facing an error on executing the below command dump name: pg_dump_FcZ0.pnps_200903041201_1.2.1.0_base_testing databae name: pnqd_test $pg_restore -U postgres -p 5433 -d pnqd_test pg_dump_FcZ0.pnps_200903041201_1.2.1.0_base_testing pg_restore: [archiver (db)] Error while PROCESSING

Re: [SQL] [GENERAL] pg_restore error - Any Idea?

Eric, There was no change in the version, we are using postgres v8.3.5 Thanks Deepak On Sun, Mar 22, 2009 at 11:17 PM, Erik Jones wrote: > > On Mar 22, 2009, at 10:44 PM, DM wrote: > > Hi All, >> >> I am facing an error on executing the below command >&

[SQL] Can we load all database objects in memory?

Hi All, I have a database of 10GB. My Database Server has a RAM of 16GB Is there a way that I can load all the database objects to memory? Thanks for your time and taking a look at this question. Thanks Deepak

[SQL] how to set the value to the column

Hi All, I have a table test with columns name and value test table name value It has around 500 rows. I added a new column id to the table, Table test id, name, value I am not sure how to insert numbers to my column id (1-500). Thanks

Re: [SQL] how to set the value to the column

never mind i got the answer. Thanks for looking into it. - deepak On Thu, Apr 16, 2009 at 12:00 PM, DM wrote: > Hi All, > > I have a table test with columns name and value > > test table > name > value > > It has around 500 rows. > > I added a new column id