We got a new instrument which stores our sample info in a database (vendor is useless, PostgreSQL 8.0, pgAdmin III 1.2.2, Win XP, only exe's in folder pg_dump and pg_restore). I would like to modeify a few items (e.g., correct typos, change file locations). The database has 56 tables; one is 'samples'. I used pg_dump to make a text file of entries. Can I just use this to modify a few entries and pg_restore without consistency errors? The table 'samples' lists 31 sample (~2 months). How can I list all the items associated with each sample number (preferably by sample name) since all the data is sorted by type first?
pgsql-novice No question is too simple for this list.
Earn ATM Machine Profits While You Sleep. Simple and Easy. Click Now.
pgsql-novice by date
|Next:||From: Wright, George||Date: 2007-10-02 14:25:30|
|Subject: Re: DST question |
|Previous:||From: Alvaro Herrera||Date: 2007-10-01 23:46:52|
|Subject: Re: PG on NFS may be just a bad idea|