Re: executing sql statements from file

From: Lee Harr <missive(at)frontiernet(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: executing sql statements from file
Date: 2002-09-21 22:55:27
Message-ID: amitcu$85g$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <3d8c77ae$0$13217$e4fe514c(at)dreader4(dot)news(dot)xs4all(dot)nl>, Frank wrote:
> Hello,
>
> how can I execute a bunch of sql queries from a file? This is normally done
> by connecting to the database and something like
>
>=> start /tmp/hutsemefluts.sql
> or
>=> @ /tmp/hutsemefluts.sql
>
> but how can this by done in PostgreSQL?
>
> thanks
>

\i /tmp/hutsemefluts.sql

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2002-09-21 23:54:41 Re: IN vs EXIIST
Previous Message Björn Lundin 2002-09-21 19:46:24 Re: shell scripting