Re: [GENERAL] Copy From csv file with double quotes as null

2010-09-08 Thread Donald Catanzaro, PhD
Hi All, I am apparently totally misreading how to import data using the COPY FROM command, can someone give assistance ? I have two issues, both dealing with double quotes as NULL. The data is CSV with NULL being represented by a double quote (e.g. "") in all columns of the table. ISSUE

Re: [GENERAL] Moving postgresql data to another computer

2010-05-11 Thread Donald Catanzaro, PhD
? -Don Richard Broersma wrote: On Tue, May 11, 2010 at 1:16 PM, Donald Catanzaro, PhD wrote: I am a newbie to PostgreSQL and I recently installed it on my desktop (Windows XP) I created a database fine and worked a bunch of queries. I am traveling now and I needed access to my database on

[GENERAL] Moving postgresql data to another computer

2010-05-11 Thread Donald Catanzaro
Good Day All, I am a newbie to PostgreSQL and I recently installed it on my desktop (Windows XP). I am traveling now (laptop is Windows Vista) and I needed access to my database. So before I left, I installed PosgreSQL on the laptop and then copied the data in the PostgreSQL data directory over

[GENERAL] Moving postgresql data to another computer

2010-05-11 Thread Donald Catanzaro, PhD
Good Day All, I am a newbie to PostgreSQL and I recently installed it on my desktop (Windows XP) I created a database fine and worked a bunch of queries. I am traveling now and I needed access to my database on my laptop (Windows Vista). So before I left, I installed PosgreSQL on the laptop