DISCLAIMER: This question is similar to the stack overflow question here, but none of those answers work for my problem, as I will explain later. I’m trying to copy a large table (~40M rows, 100+ …
Tag: postgresql
Get last record of a table in Postgres
I’m using Postgres and cannot manage to get the last record of my table: How can I do that knowning that timestamp is a unique identifier of the record ? Answer If under “last record” you mean the record which has the latest timestamp value, then try this:
Importing records from PostgreSQL to MySQL
Was wondering if anyone had any insight or recommended tools for exporting the records from a PostgreSQL database and importing them into a MySQL database. I believe the table structure is 100% identical. Thoughts? Thanks! Answer The command will generate SQL-standard-compliant INSERT statements with all colu…
PostgreSQL visual interface similar to phpMyAdmin?
I’d like to view and possibly edit tables for PostgreSQL visually like phpMyAdmin, where you can see the list of tables, and fields and individual rows for a table. Is there any utility that can do this? Forgive me if this is actually possible in pgAdmin III, but I couldn’t figure out any way to s…
PostgreSQL: SQL script to get a list of all tables that have a particular column as foreign key
I’m using PostgreSQL and I’m trying to list all the tables that have a particular column from a table as a foreign-key/reference. Can this be done? I’m sure this information is stored somewhere in information_schema but I have no idea how to start querying it. Answer This uses the full catal…
Right query to get the current number of connections in a PostgreSQL DB
Which of the following two is more accurate? Answer Those two requires aren’t equivalent. The equivalent version of the first one would be: In that case, I would expect that version to be slightly faster than the second one, simply because it has fewer rows to count. But you are not likely going to be a…
Map database type to concrete Java class
Background Map a column data type to its corresponding Java class. Problem A query returns meta information from a database: For example, this query returns (the self-referential): Where ‘dictionary’ is the schema name, ‘resource_bundle’ is the object_name, and ‘column_name’…
Default value not populating in migration with Rails and Postgresql
I am currently trying to run this migration: class AddDroppedProjectsCountToUser < ActiveRecord::Migration def self.up add_column :users, :dropped_projects, :integer, {:default=>0, :…
How do I find the largest value in a column in postgres sql?
For example: name | weight jon 100 jane 120 joe 130 How do I only return the name of the person with the largest weight?
Return multiple fields as a record in PostgreSQL with PL/pgSQL
I am writing a SP, using PL/pgSQL. I want to return a record, comprised of fields from several different tables. Could look something like this: CREATE OR REPLACE FUNCTION get_object_fields(name text)…