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

2004-12-11 Thread Bruno Wolff III
On Wed, Dec 08, 2004 at 08:58:49 -0800, Mark <[EMAIL PROTECTED]> 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

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

2004-12-11 Thread Michael Fuhr
On Wed, Dec 08, 2004 at 08:58:49AM -0800, Mark wrote: > I guess is simple, but cannot find out how to run scripts in psql( > Linux) Create a file with the SQL statements you'd like to run. There are several ways to get psql to read the file: Redirection: psql < foo.sql Command-line option: