Questions tagged [pgadmin-4]

pgAdmin 4 is an Open Source administration and development GUI for PostgreSQL.

pgAdmin 4 is a complete rewrite of pgAdmin 3.

pgAdmin4 is cross platform (i.e., Linux, FreeBSD, Solaris, macOS and Windows) and supports PostgreSQL v9.2 and above.

It is available as separate download https://www.pgadmin.org/, but also included in PostgreSQL https://www.postgresql.org/.

1180 questions
-3
votes
2 answers

Updating data when date is in condition

I am facing an issue to update the dataset with data type is date in Condition Script: UPDATE blse SET employment = 2066.3 WHERE date = (i am not sure how) AND industry = 'Total Nonfarm' AND state = 'Alabama' ;
RAKANiD6
  • 1
  • 1
-3
votes
1 answer

SQL query to query set (django) converter

See below for my query editor SELECT customer_id, MAX(date_created) AS "Last_purchase" FROM public.accounts_order GROUP BY customer_id; How will this look as a queryset on my django views?
-3
votes
1 answer

Why doesn't my query work? (SQL)

Here is my code SELECT flightid,flightdate,numseats,seatnumber,maxcapacity; FROM flight,flightbooking,seatbooking; I get and error saying: "ERROR: syntax error at or near "FROM" LINE 2: FROM flight,flightbooking,seatbooking;" ^ These are…
-4
votes
1 answer

ERROR: syntax error at or near "\" in Postgres

for load the script in my work throw me this error , i counted manually and give the line 1162 , the end of the line count 21787 , and i check that line and i'm not seeing the error Someone know what can be the trouble? also the postgres version in…
Insaf99
  • 1
  • 3
1 2 3
78
79