StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POProblems in sending input to detached 'screen' via readreg and paste
primarykey
Id
4392584
data
AcceptedAnswerId
4393553
AnswerCount
4
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-12-08T21:31:31.250
FavoriteCount
1
LastActivityDate
2012-11-29T15:20:30.837
LastEditDate
2010-12-17T04:24:25.437
LastEditorUserId
95592
OwnerUserId
535610
ParentId
0
PostTypeId
1
Score
1
ViewCount
1281
LastEditorDisplayName
text
Body
I am trying to send input to a interactive command running via screen. Here is my initial command <pre><code>screen -L -c ./customrc -S psql -d -m /opt/PostgreSQL/9.0/bin/psql </code></pre> The above command will run interactive psql in screen detach mode. The customrc is used to define a log file for the output (which I will read from another process by polling) I am using following two commands to send input to psql running in screen <pre><code>screen -S psql -X readreg p psqlcommands.sql screen -S psql -X paste p </code></pre> The problem is that the above commands do not work unless I reattach screen at least once. Once I have attached screen and detached, the above commands work as expected. I have to launch these commands via background java process hence the interactive shell (bash) is not available. My goal is to run psql in interactive mode and pass input to it and capture its output via a log file. So far I have tried to run screen via xterm (or konsole or gnome-terminal) in attach mode, use readreg/paste and then detach, but I realise that xterm will not be available in my production environment. I've also tried sending output to /proc//fd/0 but I am unable to emulate 'ENTER' from keyboard (I have to attach and press in order for the output to be accepted by psql). I think pipes and fifo may help but I am unable to figure out how to proceed with them using screen and psql. I appreciate any further hints or workarounds. Thank you, Usman.
Tags
<bash><gnu-screen><postgresql>
Title
Problems in sending input to detached 'screen' via readreg and paste
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USMatthew Rankin
UserOwnerUserId
1. USUsman Saleem
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POProblems in sending input to detached 'screen' via readreg and paste
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POProblems in sending input to detached 'screen' via readreg and paste
 UserUserId
 UScbowns
 VoteTypeVoteTypeId
 VTFavorite
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.