Re: Read data from text file - SOLVED?

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.
>
> Jenn

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
'public' schema.

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” *

and then:

*%> psql -f <fileto read> <Database> <Owner>*

*%> psql -f schemq.sql postgres radius*

It worked. Hope it help others.

Jennifer