Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
I am trying to get data like count or distinct from tables matching criteria in information_schemaSELECT count(A.searchstring) FROM (SELECT ...
Asked on 10/28/2021 by Rajnikant Sharma
2 answerI have a working function. But it only works if I literally supply both the city and country variables.CREATE OR REPLACE FUNCTION gridref_by_address(city text, country text)RETURNS SETOF research_db_gridreference AS...
Asked on 10/28/2021 by Dean Kayton
1 answerI am looking for advice on a database to potentially replace SQLite for my application. To briefly describe my DB requirements:needs to support billions of rows and the most queried...
Asked on 10/28/2021 by 2alltra8034
0 answerI'm using CentOS 8 and I have a MariaDB 10.5.4 Galera set up with three nodes. Now, I want it to create a backup to my central server from time...
Asked on 10/28/2021
1 answerI will detail my problem in good detail. I have a marketplace application so I make a decision to make a multitenant per schema approach. I like this approach because...
Asked on 10/28/2021 by wavrik
0 answerThere are three tables with the same name Pantea in my recyclebin section of pl-sql developer and I don't know how to find the one that had been dropped...
Asked on 10/28/2021 by Pantea
1 answerI am running a query from SQL Server 2019(64bit) SSMS to PostgreSQL on AWS through Linked Server. Other queries are working fine but this particular query is failing due to...
Asked on 10/27/2021
2 answerWe need to have db server (shared hosting, vps ..etc) mainly as storage (saving data) The database (PostgreSQL) is going to have <= 10 tables with data types:1 small...
Asked on 10/27/2021 by MIYUKI NARAHARA
0 answerHere's my query:DECLARE @monthStartDate date;DECLARE @monthEndDate date; SET @monthStartDate = DATEFROMPARTS(2020,6,1);SET @monthEndDate = EOMONTH(@monthStartDate); SELECT @monthStartDate, MIN([Date]), @monthEndDate, GroupId, TypeId, ...
Asked on 10/27/2021 by Kilazur
2 answerAs I gain more experience with PostgreSQL I start to question the existence of PLPython. It's considered an "untrusted" language https://www.postgresql.org/docs/10/plpython.html What I am wondering is, when...
Asked on 10/27/2021 by Chessbrain
2 answerGet help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP