Insert using psycopg giving syntax error near "INSERT INTO"

Thread Rating:

2 Vote(s) - 3.5 Average
1
2
3
4
5

Thread Modes

Insert using psycopg giving syntax error near "INSERT INTO"

nilamo
Last Thursdayist
Super Moderators

Posts: 3,458

Threads: 101

Joined: Sep 2016

Reputation: 143

Jul-21-2017, 07:39 PM (This post was last modified: Jul-21-2017, 07:40 PM by nilamo.)

(Jul-18-2017, 03:58 AM)olgethorpe Wrote: INSERT INTO "'AAPL'"

I don't know postgres, but for most databases, it's an sql error to quote a table name. If you can't just use the table name (ie: insert into AAPL), you could use brackets (ie: insert into [AAPL]), or sometimes backticks.

Find

Messages In This Thread

Insert using psycopg giving syntax error near "INSERT INTO" - by olgethorpe - Jul-18-2017, 02:54 AM

RE: Insert using psycopg giving syntax error near "INSERT INTO" - by Larz60+ - Jul-18-2017, 03:47 AM

RE: Insert using psycopg giving syntax error near "INSERT INTO" - by olgethorpe - Jul-18-2017, 03:58 AM

RE: Insert using psycopg giving syntax error near "INSERT INTO" - by Larz60+ - Jul-18-2017, 03:11 PM

RE: Insert using psycopg giving syntax error near "INSERT INTO" - by nilamo - Jul-21-2017, 07:39 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	World Clock syntax error	OscarBoots	1	201	May-03-2024, 05:20 AM Last Post: snippsat
	Syntax error for "root = Tk()"	dlwaddel	15	1,307	Jan-29-2024, 12:07 AM Last Post: dlwaddel
	SYNTAX ERROR	Yannko	3	446	Jan-19-2024, 01:20 PM Last Post: rob101
	How to insert Dashed Lines in between Rows of a tabulate output	Mudassir1987	0	537	Sep-27-2023, 10:09 AM Last Post: Mudassir1987
	sqlite3 Conn Insert Value Error	TylerDunbar	3	781	Sep-04-2023, 06:32 PM Last Post: deanhystad
	Syntax error while executing the Python code in Linux	DivAsh	8	1,723	Jul-19-2023, 06:27 PM Last Post: Lahearle
	docx insert words of previuos paragraph on next paragraph in the same position	ctrldan	7	1,297	Jun-20-2023, 10:26 PM Last Post: Pedroski55
	Code is returning the incorrect values. syntax error	007sonic	6	1,275	Jun-19-2023, 03:35 AM Last Post: 007sonic
	openpyxl insert picture problem	cools0607	2	1,640	May-03-2023, 06:48 AM Last Post: cools0607
	Insert 10gb csv files into sql table via python	mg24	2	1,989	Apr-28-2023, 04:14 PM Last Post: snippsat

Users browsing this thread: 2 Guest(s)

View a Printable Version

Insert using psycopg giving syntax error near "INSERT INTO"

User Panel Messages

Announcements