Re: Read data from text file - Mailing list 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