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

Re: Read data from text file

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Read data from text file
Date: 2009-05-25 23:37:09
Message-ID: 4A1B2BA5.6030009@sympatico.ca (view raw or flat)
Thread:
Lists: pgsql-novice
Just E. Mail wrote:
> What is the command to create a  table from a pre-written description 
> text file?
> 
> In mysql it is:
> 
> %mysql sample_db < create_xxxx.sql
> 
> In postgresql, there are schema and I want to create the DB in a 
> particulat schema!



When I have multiple schemas in one database; I generally have a user 
that "owns" each schema, as in:

      CREATE USER kevin;
      CREATE SCHEMA kevin AUTHORIZATION kevin;

Then I process the sql commands with:

% psql db_kevin kevin < create-kevin.sql



In response to

Responses

pgsql-novice by date

Next:From: Ron ArtsDate: 2009-05-26 08:32:03
Subject: I don't understand this explain output
Previous:From: Just E. MailDate: 2009-05-25 20:07:35
Subject: Read data from text file

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