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: (view raw, whole thread or download thread mbox)
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;

Then I process the sql commands with:

% psql db_kevin kevin < create-kevin.sql

In response to


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-2017 The PostgreSQL Global Development Group