Databases
StackOverflow2013
Usersdbo
USMilos
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USMilos
    primarykey
    data
    text
    plurals
    1. POIs there a way to load a Gzipped file from Amazon S3 into Pentaho (PDI / Spoon / Kettle)?
      singulars
      1. PTQuestion
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POusing postgres server-side cursor for caching
      1. USMilos
      1. VTFavorite
    2. VO
      singulars
      1. POAdding Code Snippet in PentaHo kettle User defined java Class
      1. USMilos
      1. VTFavorite
    3. VO
      singulars
      1. POCASCADE DELETE just once
      1. USMilos
      1. VTFavorite
    1. COTable after "I want such record as", column "form_submission_id" values should be "1, 2, 3" instead of "1, 1, 1". It makes no sense to be "1, 1, 1" in your case. I already edited it, but it was rejected.
      singulars
      1. POHow to do Pivoting/crosstab in PostgreSQL with dynamic field
      1. USMilos
    2. COWhen I got interested in this topic, I browsed the PgAdmin code, and that's where I (correctly?) realized that they implemented source code generation for every object from scratch! Currently, my train of thought goes in the direction of implementing plpgsql api and putting it on github. This I can do and if I get no better answer in this thread, will do. The other option is exploring the possibility of reusing some of the psql and pg_dump code and exposing it as pg extension. Although I have some C experience, I would probably not get very far short-term.
      singulars
      1. PO
      1. USMilos
    3. COTrouble is I can't use meta-commands (It's what they are called in the official psql docs). For my use case it is only useful as a help tool in building my own api, when I write the pg_catalog queries. This really makes me wonder: Why did PostgreSQL wrap it in meta-commands and pg_dump, but left sys functions so elementary. Sure, one can program an equivalent of meta-command in any stored procedure language available, but that seems to me like code duplication. Also, for every new version you have to go through relase notes and maintain the code.
      singulars
      1. PO
      1. USMilos
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload