Search results for query: *

Thank you. I did try that (finally, after our server was restored). However, it still does not work. I get the following output: Enter number please ? FORTRAN Runtime Error: ? Attempt to read past end of file ? READ(UNIT=*,... It seems it just is not pausing to wait for user input. Any...

So - there is no way to have a continuous prompt for user input and then a special terminating character within a script?

Eventually, I would create a script to read values from a user into the postgresql db. In that script, it prompts the user to enter values needed. I just wanted to test this from the command line.

Is there a way to retrieve user input for postgresql? I have done a search online and found that one can use: select * from mytable where user_id = [parameter "Enter text question here"] --or-- select * from mytable where user_id ~* '[parameter "Enter text question here"]' However, when I type...

Thank you - it worked by listing the values and leaving off the default incrementer.

The good news is, I have figured out what the problem was with the above query - I was using the wrong field as the auto increment. However, once one problem is solved, another pops up. I am looking into how to perform an insert into a table using a select statement. Here are the 3 queries I...

I'm not too sure how to use the sequence identifier. As for the date fields - I simply cut out some of the declarations in the overlay table. I cannot seem to get the auto increment field to work. Is there anything else I can do to fix that auto increment field?

I am fairly new to PostgreSQL. I am in the process of converting a MySQL script to postgresql. The mysql script includes a line that reads: INSERT INTO OVERLAY VALUES (NULL,LAST_INSERT_ID(),'Grey Standard','basemap',1,'png','y',-1,0,NOW(),NOW()), (NULL,LAST_INSERT_ID(),'Brown...