Re: Read data from text file - Mailing list pgsql-novice

From Just E. Mail
Subject Re: Read data from text file
Date
Msg-id 4A1C76FB.9000904@imwell-usa.com
Whole thread Raw
In response to Re: Read data from text file  (Frank Bax <fbax@sympatico.ca>)
Responses Re: Read data from text file - SOLVED?
List pgsql-novice
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)?


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Conditional ALTER TABLE
Next
From: Dennis Clark
Date:
Subject: Re: Tool for modeling