Re: Read data from text file

From: "Just E(dot) Mail" <justemail(at)imwell-usa(dot)com>
To: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Read data from text file
Date: 2009-05-26 23:10:51
Message-ID: 4A1C76FB.9000904@imwell-usa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)?

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Dennis Clark 2009-05-26 23:52:34 Re: Tool for modeling
Previous Message Tom Lane 2009-05-26 23:03:47 Re: Conditional ALTER TABLE