Stack Overflow
Stack Overflow

Questions tagged [postico]

33 questions
7
votes
2 answers

Cannot connect to postgreSQL docker container via postico

I'm trying to use Postico to connect to a docker postgreSQL container on my local machine. I've tried connecting to 0.0.0.0, localhost, and 127.0.0.1. Each give me the following error: could not connect to server: Connection refused Is the…
Jon Leopard
  • 835
  • 1
  • 12
  • 24
5
votes
1 answer

How to import data from PostgreSQL database to R?

I'm thinking of importing data from database directly into r using RPostgresQL package. So far, I used to write queries in Postico (a PostgreSQL client) software and export as csv and then import the csv file into R. This is what I've written so far…
Mohamad Sahil
  • 165
  • 2
  • 12
3
votes
1 answer

Group by time with timezone conversion in Postgresql

I am working with time data that is currently stores in UTC but I want it to be in PST, which is 8 hours behind. I have a pretty lengthy and involved query, but the only thing I am interested in is the time right now so I have included those parts.…
Jane Sully
  • 3,137
  • 10
  • 48
  • 87
2
votes
0 answers

Positco is returning an incorrect timestamptz than what is being passed in with psycopg2

I have a simple script that is passing in a timestamp into a Postgres database. I am viewing the DB with Postico. I am attempting to pass in a UTC value, by which I mean I want the DB to store all values at +00 timezone. I am using a timestamptz…
mypythonquestions
  • 83
  • 1
  • 8
1
vote
1 answer

How can I sync my Flutter Serverpod project on multiple Mac's remotely?

I have created a Flutter Serverpod project on MacBook Air M1. Then i uploaded it to GitHub, now my question is whenever I download the project from GitHub to my iMac(not the same host mac). I don't find my project's container in docker on that Mac…
Husain Nahar
  • 21
  • 1
1
vote
1 answer

PostgreSQL said: permission denied for schema

I have a multi-tenant PostgreSQL db on a Ruby on Rails app, and when I try to access to tables on some schemas on Postico, I get the following error: Failed to load table schema. Query failed PostgreSQL said: permission denied for schema coaching I…
Matteo
  • 53
  • 1
  • 5
1
vote
2 answers

How do I format text array and hstore data in a CSV/TSV file for importing into Postgres

I’m trying to import text arrays and hstore values into Postgres from a CSV (actually TSV) spreadsheet, but I keep getting multiples of these two errors: ERROR: Syntax error near '}' at position 667 ERROR: malformed array literal: "" Detail: Array…
eggroll
  • 1,049
  • 9
  • 18
1
vote
2 answers

how to access columns if they are named after numbers

My column names in my table are just numbers from 0-20, where each column is corresponding to a number however, when I try select 0 from table I get output of only zeroes in my column, how can I select a column without changing the column…
mei
  • 35
  • 8
1
vote
0 answers

Connection to remote machine postgresql database

I am trying to connect to a VM ubuntu from my local computer. On the VM I have created a postgresql database. Then I followed all steps that I could find on several tutorial when it comes to allow access for remote connexion to the db: add host all…
delalma
  • 838
  • 3
  • 12
  • 24
1
vote
2 answers

How to convert Swift Date or String to timestamp without time zone of PostgreSQL?

I am using Vapor 3, Swift 5.1, PostgreSQL 12, and Postico 1.5.10 for my Backend. In the PostgreSQL database, there is a field with the name eventDate of type timestamp without time zone. Please, look at screenshot: In Vapor, there is a…
Alex
  • 1,038
  • 2
  • 12
  • 32
1
vote
0 answers

How can I verify the AWS Postgres SSL cert when it is self-signed?

I'm trying to clear a SQL client error (in Postico) saying that the AWS certificate for our Postgres server (through Heroku) is not trusted. The instructions I've found all assume that the certificate has a Root Authority, and that adding that to…
Freewalker
  • 6,329
  • 4
  • 51
  • 70
1
vote
1 answer

postgres query to update json field

In PostgreSQL databse, I have a table called hotel, which has a column called hotel_info. This hotel_info column stores json object like below { "hotel":{ "room_details":{ "customer_detail":{ "first_name" : "aaa" } …
Thangakumar D
  • 714
  • 5
  • 12
  • 27
1
vote
0 answers

Time groups showing off by one day in postgresql query

I have a query where I compute various statistics and metrics, and group by dates in the last week. The times do not have a time zone associated with them, but are displayed in UTC so I want to convert them to Pacific time first. When I get dates…
Jane Sully
  • 3,137
  • 10
  • 48
  • 87
1
vote
0 answers

Why is Positco returning an incorrect timestamptz than what is being passed in with psycopg2

I have a script that is passing in a timestamp into a Postgres database. I am viewing the DB with Postico. I am attempting to pass in a UTC value, by which I mean I want the DB to store all values at +00 timezone. I am using a timestamptz entry in…
mypythonquestions
  • 83
  • 1
  • 8
1
vote
1 answer

Is Postgres caching our queries and how do we get around it?

I'm trying to run the following piece of python3 code: import os import psycopg2 import logging # Set max attempts before giving up MAX_ATTEMPTS = 5 # Set basic logging config to debug (i.e. log everything). # By default, this will log te stdout…
Shaundavin13
  • 69
  • 6
1
2 3