I set up mage-ai and postgresql containers via docker. I was able to successfully create the database during initialization of the container, could verify the existence of it via docker desktop. I wanted to connect to the same db using…
I am creating a table in Postgresql, this DDL is the result of a script that I am making to compare bancos. CREATE TABLE projeto_modelo.exemplo_fk1 ( id SERIAL NOT NULL, nome varchar(30) NOT NULL, criado_em timestamp NOT NULL, id_exmp_fk2 int4…
I create a container posgresql with this command: docker run --name posgre_db -e POSTGRES_USER="user" -e POSTGRES_PASSWORD="password" -p 5432:5432 -d postgres:latest when i try to create a connection with DBeaver i get a error: I can go into the container λ…
I'm trying to backup from one database and restore on other database both with the same version(12.9). I have one table with large objects(OID) and when I restore the backup the large objects are missing. I have the OID on…
In my postgres database I have a table I'll call users with a timestamptz type column updated_time. When I execute a select statement on this field I will get something like this - '2024-07-01 12:30:30.821 -0500'. However, if I turn…
From DBeaver Community, I access my database and create a new SQL query. I write the corresponding code for the CTE I want to create, but it constantly shows a syntax error. I've tried everything, but I can't find the…
Let's say I have two server A and B. Server A is open to public. Server B is only allow connection from server A. My MySQL database is located on server B. From my local machine, how to I connect…
I have a SQL query: select max(date) from index_constituents where (opening_closing ='O' and index_code ='buk350n' and issuer = 'cboe') and date = '2024-04-25'; id date issuer index_code opening_closing 1393 2024-04-25 cboe buk350n O 1394 2024-04-25 cboe buk350n O When I…
I have a function & I'm checking whether the table and column exist or not. If exits, then I need to alter the table. delimiter $$ create function column_exists(ptable varchar(300), pcolumn varchar(100)) returns CHAR reads sql data begin declare result…
When I connect via psql with this command docker exec -it 4e18793cb23c psql -U postgres mytestdb, I can see my database and work with it. But when I connect with dbeaver to my postgres docker container, it doesn't show me…