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