Python Forum
Sequential number for rows retrieved and storing the Primary UKey to the line number
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sequential number for rows retrieved and storing the Primary UKey to the line number
#3
(Aug-22-2023, 10:01 AM)menator01 Wrote: What have you tried? How is the data stored. You will need to show your code for getting help.

Thank you. Currently, data is stored in the Postgres database

elif usermenuoption == 3:
cur = conn.cursor()
cur.execute("SELECT * FROM python_test")
records = cur.fetchall()
print(tabulate(records))
print("\nALL RECORDS DISPLAYED.")
Reply


Messages In This Thread
RE: Sequential number for rows retrieved and storing the Primary UKey to the line number - by GYKR - Aug-22-2023, 10:14 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
Music Python Script Repeating Number When Saving Facebook Photos ThuanyPK 2 138 May-13-2024, 10:59 PM
Last Post: ebn852_pan
  intering int number akbarza 1 273 Apr-28-2024, 08:55 AM
Last Post: Gribouillis
Brick Number stored as text with openpyxl CAD79 2 566 Apr-17-2024, 10:17 AM
Last Post: CAD79
  Reading and storing a line of output from pexpect child eagerissac 1 4,348 Feb-20-2024, 05:51 AM
Last Post: ayoshittu
  [SOLVED] Pad strings to always get three-digit number? Winfried 2 419 Jan-27-2024, 05:23 PM
Last Post: Winfried
  Prime number detector Mark17 5 896 Nov-27-2023, 12:53 PM
Last Post: deanhystad
  Create X Number of Variables and Assign Data RockBlok 8 1,052 Nov-14-2023, 08:46 AM
Last Post: perfringo
  find the sum of a series of values that equal a number ancorte 1 539 Oct-30-2023, 05:41 AM
Last Post: Gribouillis
  capturing multiline output for number of parameters jss 3 864 Sep-01-2023, 05:42 PM
Last Post: jss
  python sqlite autoincrement in primary column janeik 6 1,280 Aug-13-2023, 11:22 AM
Last Post: janeik

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020