Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using variables while redirecting input from file?

Status
Not open for further replies.
fig

fig

Programmer
Apr 29, 2001
1
0
0
US
If I want to test some SQL with the following at the CLI:

Code: 
psql test < test.sql > test.txt

...is there a way to set a variable with a SELECT, and then use that variable when doing a subsequent INSERT in the test.sql file?

Ideas?

Thanks,
fig
 
Status
Not open for further replies.

Similar threads

beakerboy
  • Locked
  • Question
Query from tables sharing primary keys
Replies
0
Views
48
beakerboy
beakerboy
mlgmartin
  • Locked
  • Question
How to free up disk space from Smoothwall's /var/log folder?
Replies
0
Views
63
mlgmartin
mlgmartin
spperl
  • Locked
  • Question
Like Search using full text index
Replies
1
Views
42
spperl
spperl
ca8msm
  • Locked
  • Question
Copy Database from Linux to Windows 1
Replies
3
Views
91
stefanwagner
stefanwagner
AP81
  • Locked
  • Question
using COPY command with SQL query
Replies
1
Views
38
feherke
feherke

Part and Inventory Search

Sponsor

Back
Top