bill house <wchouse(at)bellsouth(dot)net> writes:
> I am trying to learn how to construct SQL commands using information
> derived from other SQL commands/querys.
> These commands are stored for the moment in a simple text file which
> would be executed by the psql client like so:
> current_database=# \i sql_command_file.sql
This is really getting beyond what you can do usefully with a simple
psql text file. My first suggestion would be to see if you can write
what you need as a plpgsql function.
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: bill house||Date: 2010-02-01 03:27:21|
|Subject: Re: variable substitution in SQL commands|
|Previous:||From: bill house||Date: 2010-01-31 21:03:19|
|Subject: variable substitution in SQL commands|