Skip site navigation (1) Skip section navigation (2)

how to edit entries in vendor supplied database?

From: "sandy_mcd(at)juno(dot)com" <sandy_mcd(at)juno(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: how to edit entries in vendor supplied database?
Date: 2007-10-02 03:31:29
Message-ID: (view raw or whole thread)
Lists: pgsql-novice
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? 
thanks much

(files available)

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, GeorgeDate: 2007-10-02 14:25:30
Subject: Re: DST question
Previous:From: Alvaro HerreraDate: 2007-10-01 23:46:52
Subject: Re: PG on NFS may be just a bad idea

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group