EXPLAIN CREATE TABLE TestTbl ( EId integer PRIMARY KEY, FullName VARCHAR(50) NOT NULL ) This query results in an error: ERROR: syntax error at or near "integer" LINE 2: EId ...

I'm trying to create this partitioned table in my PostgreSQL database: create table messages_table ( id bigserial not null, class_name varchar(255), date_created timestamp, service ...

I'm using Spring Boot with Hibernate 6+ and PostgreSQL, and I want Hibernate to generate tables only for entities that explicitly declare a schema using @Table(schema = "schema_name"). For ...

I am looking at some table DDL and I noticed we have two different data types. uuid _uuid (yes, it's literally "_uuid") I have never seen this before, what is the difference between them?

In our SpringBoot 2.7, Java 8, postgres 15 app, we can use the entity Manager to run queries with arbitrary SQL. However, this approach does not work for us for DDL statements like create table. ...

I’m working on a script to get the direct download link from a normal MediaFire link. But when I try to make a request to the MediaFire URL, I don’t get the actual HTML page. Instead, I get a page ...

I have flashback enabled (as sysdba) for a table on my oracle 19 database: CREATE FLASHBACK ARCHIVE flashback_at0672 TABLESPACE users QUOTA 10G RETENTION 1 YEAR; ALTER TABLE at0672.assays ...

In a clickhouse table (with MergeTree engine), there is a column with ~500GB of compressed data (according to the info in system.parts_columns table). However, when I dropped this column using ALTER ...

I have a problem. I put the @Check annotation with the appropriate checks over the entity field. Further, I tried to generate the migration file both through the “DDL by Entities” function and through ...

I've faced with a problem in one of my projects - created local db from dump file (Postgre 13), some columns were defined like varchar[] and interval. CREATE TABLE public.table ( id integer ...

I am trying to create a separate users for my DDL and DML operations on postgres. I am using the public schema. REVOKE ALL ON DATABASE app FROM PUBLIC; REVOKE ALL ON SCHEMA public FROM PUBLIC; CREATE ...

I'm trying to run a statement in Teradata, using DBeaver 24.2. When I run my statement in Teradata SQL Assistant, it runs perfectly, but when I run it using DBeaver, I'm getting the following error: ...

I have an postgres 16 DB in Docker container with volume. I wanted to hide standard postgres user and changed it's name to super (as example). Now I try to make something with any tables (DDL ...

Given is a Firebird 5.0 table with this DDL: CREATE TABLE KASSE_DETAILEDSTATISTICS (ORDERDATE KASSE_ORDERTIMESTAMP NOT NULL, PRODUCTID KASSE_PRODUCTID NOT NULL, CONSUMPTIONPLACE KASSE_INHAUS ...

I was trying to duplicate data from an existing table to an empty table in different schema (all in the same database) and got an error. (PostgreSQL 16): This is for specific exercise, so I have to ...