Skip site navigation (1) Skip section navigation (2)

Re: Read data from text file - SOLVED?

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 - SOLVED?
Date: 2009-05-27 10:30:57
Message-ID: 4A1D1661.9000307@imwell-usa.com (view raw or flat)
Thread:
Lists: pgsql-novice
Just E. Mail wrote:
> 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)?
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

In response to

Responses

pgsql-novice by date

Next:From: Just E. MailDate: 2009-05-27 14:23:23
Subject: Re: Read data from text file - SOLVED?
Previous:From: Anirban PalDate: 2009-05-27 07:51:40
Subject: Postgres registry access using java

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group