postgresql Archives - Page 3 of 21

postgresql, Programming

IT Nursery

How do you find the disk size of a Postgres / PostgreSQL table and its indexes

I’m coming to Postgres from Oracle and looking for a way to find the table and index size in terms of bytes/MB/GB/etc, or ...

June 1, 2022
0 Comments

postgresql, Programming

IT Nursery

Tools to generate database tables diagram with PostgreSQL? [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. We don’t allow questions seeking recommendations for books, ...

June 1, 2022
0 Comments

Programming, ruby-on-rails

IT Nursery

Rails: Installing PG gem on OS X – failure to build native extension

It seems many others have had problems installing the pg gem. None of the solutions posed for others have worked for me. I ...

June 1, 2022
0 Comments

Database, Programming

IT Nursery

Generate the ERD for an existing database [closed]

Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so ...

June 1, 2022
0 Comments

Programming, sql

IT Nursery

Postgresql – change the size of a varchar column to lower length

I have a question about the ALTER TABLE command on a really large table (almost 30 millions rows). One of its columns is ...

June 1, 2022
0 Comments

Database, Programming

IT Nursery

How do I automatically update a timestamp in PostgreSQL

I want the code to be able to automatically update the time stamp when a new row is inserted as I can do ...

May 31, 2022
0 Comments

json, Programming

IT Nursery

Check if a Postgres JSON array contains a string

I have a table to store information about my rabbits. It looks like this: create table rabbits (rabbit_id bigserial primary key, info json ...

May 31, 2022
0 Comments

postgresql, Programming

IT Nursery

How to get min/max of two integers in Postgres/SQL?

How do I find the maximum (or minimum) of two integers in Postgres/SQL? One of the integers is not a column value. I ...

May 31, 2022
0 Comments

Programming, sql

IT Nursery

How to check if a table exists in a given schema

Postgres 8.4 and greater databases contain common tables in public schema and company specific tables in company schema. company schema names always start ...

May 31, 2022
0 Comments

json, Programming

IT Nursery

PostgreSQL return result set as JSON array?

I would like to have PostgreSQL return the result of a query as one JSON array. Given create table t (a int primary ...

May 31, 2022
0 Comments