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 efross...@gmail.com wrote: Tom Lane wrote: Edward Ross efross...@gmail.com writes: Here is a sandbox example of what I mean. CREATE TABLE test_0 ( string_value

[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 dm.a...@gmail.com 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 to the table, Table test

[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

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 ejo...@engineyard.com wrote: On Mar 22, 2009, at 10:44 PM, DM wrote: Hi All, I am facing an error on executing the below command dump name: pg_dump_FcZ0

[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