While copying the data from a CSV file it's throwing the issue as: SQL Error [23514]: ERROR: new row for relation The location of the CSV file and the table name have been checked. I have tried using different delimiter…
I want to declare and assign variables on a Postgres 12.10 instance. According to the Postgres documentation I should be able to declare and assign variables as follows DECLARE x integer := 1; y integer := x + 1; but…
I can't find how to check each element of an array-field in a table. Be like: create table tab ( day_in_mounth int[12] check ( *every array element* > 0 and < 30) ); values < 0 and > 30 must…
I am using spring-data-jpa here is my query @Query(value = "select ea.* from employee ea where ids in (?1) and (?2 is null or country=?2) ", nativeQuery = true) Page<Employee> findByds(List<UUID> ids,String country ,Pageable pageable ); I want to get…
How to correct below misspelled data in column market: market SocialMediaAdvertising SocialInvesting FinancialExchanges CloudMagement VentureCapital I don't know what syntax to write. But output should be as below: market Social Media Advertising Social Investing Financial Exchanges Cloud Magement Venture Capital
I want to show the percentage of companies with crowdfunding vs. companies without crowdfunding. I tried below but I just can't get it to work. WITH with_crowdfunding AS (SELECT COUNT(market) FROM investment_finance WHERE equity_crowdfunding > 0), no_crowdfunding AS (SELECT COUNT(market)…
Products have names like Product one white Adidas Other product black Hill sheet Nice T-shirt blue Brower company How to get starting part of product name before first uppercase word starting from second word and up to first uppercase word…
I have 3 tables; idmaster data1 data2 idmaster has every id. I need to count how many times each id exists in both data1 and data2 and output them seperate. id comes from idmaster. Ideally would like to have all…
I have a table "blobs" with a column "metadata" in jsonb data-type, Example: { "total_count": 2, "items": [ { "name": "somename", "metadata": { "metas": [ { "id": "11258", "score": 6.1, "status": "active", "published_at": "2019-04-20T00:29:00", "nvd_modified_at": "2022-04-06T18:07:00" }, { "id": "9251",…
I have windows based application that communicates with PostgreSQL (installed on another Windows Server). Currently I use connection string with username and password (user is configured on PostgreSQL DB). Is it possible to somehow change it so that in connection…