Linked Questions

Ask Question
215 questions linked to/from Are PostgreSQL column names case-sensitive?
Hot Newest Score Active Unanswered
9 votes
1 answer
11k views

My psql table structure like below: id userName gender 1 xxxx Male if I am using query like below from psql shell: select * from table where userName="xxx"; It gives error: Error: ...
Mohammed Yasin's user avatar
  • 537
23 votes
1 answer
82k views

I managed to create a table in a schema FOO. Whenever I then try and do anything, like even a basic select, I just get: ERROR: schema "FOO" does not exist SQL state: 3F000 Character: 15 I am running ...
aaa90210's user avatar
  • 12.3k
0 votes
1 answer
4k views

I am using SQL query to get a specific user from the table, however, I am running into the issue where the postgresql is telling me that the column does not exist. It is a simple query statement that ...
Tim Tran's user avatar
  • 11
0 votes
1 answer
2k views

I have a simple query that isn't working. select * from table where '"Name (xyz)"' LIKE '%AB CD EF G%'; I am trying to return the row such that the column Name (xyz) = AB CD EF G . I have ...
daniel stafford's user avatar
  • 231
2 votes
4 answers
2k views

below is the SQL query ran in Postgres and its corresponding output. The data type for the column 'premiseId' is text which is the equivalent of varchar (without any length specifier). So my query is ...
Eugene's user avatar
  • 1,147
2 votes
1 answer
570 views

I already have a database created by postgresql (provided by another administrator than me), the command is created as shown below. CREATE TABLE "Districts" ( "Name" character varying(500), "...
ngtonhung's user avatar
  • 55
0 votes
0 answers
1k views

I have created two tables and tried to join them, but it resulted in Query Error. What could be the problem? Here is how I created tables CREATE TABLE Customer ( "Ids" int, "...
Ruslan Pylypyuk's user avatar
  • 57
0 votes
0 answers
732 views

Hi I'm connecting to postgres database and transfer data to my local machine. here is my code : public DataTable GetDataTable(string sql) { var conn = GetOpenConnection(); ...
Gayan's user avatar
  • 1,563
1 vote
0 answers
566 views

I downloaded a PostreSQL file that creates and populates the Chinoook database (a relatively well known database used for testing). I then opened the file on sqliteonline (an online compiler where you ...
Arturo Sbr's user avatar
  • 6,421
0 votes
1 answer
272 views

I created a trigger that allows me each time the hen I add a lot to the table amount he adds this amount in the article table, but my error says that the registration (new) items. CREATE TABLE ...
isom's user avatar
  • 304
1 vote
1 answer
452 views

I have 2 tables in postgres, product and product2 I cannot query product2 query 2 works well, query 1 and 3 does not run and gives error "relation does not exist" please help.
yılmaz's user avatar
  • 451
0 votes
1 answer
203 views

I am trying to run this very simple query unless ram.blank? list = list.where(['numRam >= ?', ram]) end it works perfectly on my local server where I am using mysql as my database, but it ...
amronrails's user avatar
  • 100
0 votes
0 answers
114 views

I have written a script in python in which I am trying to access the Y1 column of the database. But the command line is giving me the error stating that column Y1 does not exist. But the column is ...
yogesh's user avatar
  • 5
0 votes
1 answer
180 views

I have several databases on PostgreSQL under W11 pro. I want to delete some of them but it returns error. I started the PSQL.exe into a CMD instance ran as Administrator. For instance I want to delete ...
Tormy Van Cool's user avatar
  • 801
0 votes
0 answers
70 views

A SQL coding challenge provided a database; every table was accessible when passed as a string using double quotes and not when passed as a word as I am normally used to. This did not work: SELECT * ...
Digvijay Patil's user avatar
  • 37

15 30 50 per page
1
2 3 4 5
…
15