python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - cockroachdb

show filter values even if the data is not available in table

So there is the Table and their contents As shown below. id title image 1 First row 2 Second row 3 third row So if we see in the table there are only 3 records and the id are 1,2,3 The...
test-img

user9243500

postgresql

cockroachdb

Votes: 0

Answers: 1

Latest Answer

You can't do this with the IN operator, but you could OUTER JOIN to a VALUES clause or unnest an array: SELECT id, title, image FROM table RIGHT OUTER JOIN (SELECT unnest(ARRAY[1, 2, 3, 4, 5])) as u(i...
test-img

Jeremy

Using Flyway for two databases, but only one at a time

I'm testing out PostgreSQL and CockroachDB with my application. I've got it such that I can run my application with either PostgreSQL OR CockroachDB. Is it possible to set Flyway up such that I can ru...
test-img

NDB

java

postgresql

spring-boot

flyway

cockroachdb

Votes: 0

Answers: 1

Latest Answer

The default behavior of Flyway uses the config file. Issuing a command like flyway migrate will go to the configured database with the designated locations (folders where the migrations are stored). S...
test-img

Grant Fritchey

Problem reading from rest api with autogenerated BigInt Id

I'm having some issues with my rest api when I try to read from database. My server stack right now is NestJS + Prisma + Cockroachdb At first when I generated a new User, with a POST, all went great a...
test-img

pedrosc94

typescript

nestjs

prisma

bigint

cockroachdb

Votes: 0

Answers: 0

How do I clone a schema?

Suppose I have an existing schema (s1) with the following tables: s1.table1 s1.table2 I would like to clone this schema to a new schema (s2) i.e.: s2.table1 s2.table2 How can I achieve this? The purpo...
test-img

happymeal

cockroachdb

Votes: 0

Answers: 1

Latest Answer

You can copy a table's definition to a new table, without copying the data in the original table using CREATE TABLE ... LIKE: CREATE TABLE s2.table1 (LIKE s1.table1 INCLUDING ALL); CREATE TABLE s2.tab...
test-img

Marcus

Posts

Questions

Blogs

Jobs