Re: question: how to preload data and excute table creation scripts

On Wed, Dec 08, 2004 at 08:58:49 -0800,
  Mark  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.)