I believe I figured out how to solve this problem:
> 1. No need to create my own database 'my_db',
> 2. Create a new SCHEMA in the 'postgre' database,
> 3. set search path to my SCHEMA,
> 4. Load/insert data from a text file.
> That's it. I have not tried it yet but the research I did shows that
> it will work.
For those who are following or may read this post in the future:
My plan listed above did not work. When I tried to change the DEFAULT
SCHEMA using SET command, the data will still be inserted into the
Finally I figured out that the DEFAULT setting is set in
'postgresql.conf' file; therefore I hanged the following line:
*search_path = ‘”$user”,public” ; “#” & Change to
search_path = ‘”$user”,fr_schema” *
*%> psql -f <fileto read> <Database> <Owner>*
*%> psql -f schemq.sql postgres radius*
It worked. Hope it help others.
In response to
pgsql-novice by date
|Next:||From: Zach Calvert||Date: 2009-05-27 14:28:18|
|Subject: Query Optimization|
|Previous:||From: Just E. Mail||Date: 2009-05-27 10:30:57|
|Subject: Re: Read data from text file - SOLVED?|