Re: newbie question: reading sql commands from script

On Mon, 2005-10-24 at 20:39 -0400, Sean Davis wrote:
> In psql, look at \i.
>
> Sean
>
>         ----- Original Message -----
>         From: basel novo
>         To: pgsql-general@postgresql.org
>         Sent: Monday, October 24, 2005 8:28 PM
>         Subject: [GENERAL] newbie question: reading sql commands from
>         script files
>
>
>         What is the equivalent of the mysql 'source' command for
>         reading sql
>         commands from ascii script files?

Also, for shell scripting, there are command line options:

   psql -f filename

or redirection:

   psql < filename

(the former gives line numbers), or for a single command:

   psql -c "sql command"

--
Oliver Elphick                                          olly@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
                 ========================================
   Do you want to know God?   http://www.lfix.co.uk/knowing_god.html