Re: Read data from text file

Frank Bax wrote:
>
> Then I process the sql commands with:
>
> % psql db_kevin kevin < create-kevin.sql

I am making progress but still not there.

Using pgADMIN, I created database name 'my_db'. Under 'my_db', I created
a 'SCHEMA' named 'test' (so under 'my_db' there are two SCHEMAs ; public
& test). I use the command to read a schema text file:

% psql   my_db   radius  <  schema.sql

and each time the tables are created in the 'public' schema. How to
direct 'psql' command to insert the tables into the 'text' (or any other
SCHEMA I so desire)?