Tom,
Thanks for the advice. I'll track it over the next couple weeks and see
what comes up.
Mark
On Tue, 2006-05-09 at 17:01 -0400, Tom Lane wrote:
> <[EMAIL PROTECTED]> writes:
> > I had an odd situation occur this morning with PGSQL 7.4 run on Red Hat
> > Enterprise 4 (update 3) and could re
Robert,
If you have the luxury of taking the production db offline for a few minutes
or if you're just making changes in a test environment, this process works:
given:
create table test1 (
id integer,
txt1text,
txt2text
);
execute at command line:
pg_dump [dbname]> bac
if your output is from a query do
insert into mytable(col1, col2, col3)
(select col_a, col_b, col_c from othertable);
or
use the copy command
ex.
copy mytable from 'filepath/filename' using delimiters '\t';
you can also use stdin as the input path.
On Friday 27 May 2005 02:28 pm, Lo
