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.)