Re: question: how to preload data and excute table creation scripts - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: question: how to preload data and excute table creation scripts
Date
Msg-id 20041211193240.GB2668@wolff.to
Whole thread Raw
In response to question: how to preload data and excute table creation scripts  (Mark <sendmailtomark@yahoo.com>)
List pgsql-general
On Wed, Dec 08, 2004 at 08:58:49 -0800,
  Mark <sendmailtomark@yahoo.com> wrote:
> Hi,
>
> I guess is simple, but cannot find out how to run scripts in psql(
> Linux)
>
> What I would like to do is following:
>
> 1. Create a table structure from scripts ?
> 2. Preload data to remote Linux box (IP added to conf file)

You can use psql to do things like this.
psql < ddl.sql
psql < copy.sql

(Where dd.sql holds the ddl creation commands and copy.sql holds the
copy commands to load the data. You can look at pg_dump output for
examples.)

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Select after insert to the unique column
Next
From: David Fetter
Date:
Subject: Re: What's faster