Tag: postgresql postgresql 1570 Questions Ask question Search Order By: ActiveTagClear Filter 1 Votes 0 Ans Proper storage of a uniform, XYZ plane, in Postgres PostGIS 430.05K viewsgeometry multipoint polygon postgis postgresql 3 Votes 1 Ans Django, Postgis, and Heroku: relation “spatial_ref_sys” does not exist 1.17M viewsdatabase-schema django heroku postgis postgresql 2 Votes 1 Ans Suggestion on table partitioning in POSTGRES 1.21M viewsdata-modeling database-schema partitioning postgresql 0 Votes 1 Ans How to display a UUID in pg-promise without dashes 630 viewspg-promise postgresql uuid 3 Votes 3 Ans How to assure that DB (Postgres) connection is still alive between prepare and execute? 1.24M viewsconnection dbd-pg perl postgresql reconnect 0 Votes 2 Ans How to write a migration to convert JSON field to Postgres Array for querying in rails? 798.99K viewspostgresql rails-migrations ruby-on-rails 0 Votes 0 Ans Rails Postgres migrations: invalid type name “jsonb USING content::jsonb” or invalid type name "jsonb USING CAST(content AS jsonb) 458.16K viewspostgresql rails-migrations ruby-on-rails 0 Votes 1 Ans Sequlize nodejs table 1.10M viewsmysql node.js postgresql sequelize-typescript 13 Votes 1 Ans Spark streaming multiple sources, reload dataframe 383.88K viewsapache-spark apache-spark-sql postgresql spark-streaming 2 Votes 0 Ans How do I connect to different versions of Postgres using DBD::Pg on one system 122.04K viewsdbd-pg dbi perl perlbrew postgresql 410 Votes 11 Ans How to log PostgreSQL queries? 342.92K viewsModerator Changed status to publish September 11, 2022logging postgresql 95 Votes 5 Ans Rails auto-assigning id that already exists 1.12M viewspostgresql ruby-on-rails ruby-on-rails-3 0 Votes 1 Ans Create a new record with one2many 1.28M viewsodoo postgresql python record 2 Votes 1 Ans Connection refused when running mix ecto.setup command, packages installed with asdf 409.12K viewsasdf-vm elixir graphql postgresql 0 Votes 1 Ans PostgreSQL index for jsonb @> search 791.49K viewsjsonb postgresql sql 4 Votes 1 Ans What postgres privileges are required for Apache Airflow database backend? 302.84K viewsairflow postgresql 2 Votes 1 Ans How to combine separate pg-promise queries into one result in pg-promise 281.41K viewsnode.js pg-promise postgresql 3 Votes 1 Ans Objection.js – Query builder not a function using insert method 1.15M viewsjavascript node.js objection.js postgresql 173 Votes 11 Ans Truncating all tables in a Postgres database 482.44K viewsdatabase-table dynamic-sql plpgsql postgresql truncate 0 Votes 1 Ans LogIn with spring security not work 233.48K viewsjava jdbc postgresql spring thymeleaf 0 Votes 1 Ans Envers + Spring JPA: revinfo does not allow ‘user’ column 1.23M viewshibernate hibernate-envers postgresql spring-data-envers 1 Votes 0 Ans How to set PostgreSQL script parameters in DBeaver or PgAdmin? 323.83K viewsdbeaver pgadmin postgresql postgresql-12 30 Votes 6 Ans Rails Migrations: tried to change the type of column from string to integer 192.56K viewscasting postgresql rails-migrations ruby ruby-on-rails 1 Votes 0 Ans Rails: get a migration error for indexing jsonb with gist 1.44M viewsindexing jsonb postgresql rails-migrations ruby-on-rails 1 Votes 2 Ans POSTGRES PROCEDURE with wildcard 1.22M viewspostgresql postgresql-12 sql 10 Votes 3 Ans Importing .csv with timestamp column (dd.mm.yyyy hh.mm.ss) using psql copy 1.34M viewscsv postgresql postgresql-9.2 psql timestamp 0 Votes 1 Ans How to do in-memory search for polygons that contain a given point? 90.32K viewsgeohashing point-in-polygon polygon postgresql redis 0 Votes 1 Ans How postgresql manage columns 375.70K viewsdatabase postgresql postgresql-9.1 0 Votes 1 Ans SERIAL PRIMARY KEY keeps counting when the csv importing file fails in pgAdmin 170.29K viewsdatabase-sequence import-csv postgresql primary-key 7 Votes 1 Ans Where are NUMERIC precision and scale for a field found in the pg_catalog tables? 1.49M viewsinformation-schema postgresql 1 2 3 … 52 53 Next »