How to find file size of tables where column id = value in postgres/sql

How would I find the total size of tables where the column_id = 'value'?

I have a column which is called 'platform_id' and it is within many tables within my database, but not all of them.

I am trying to figure out how large the tables are that have the platform_id equal to 99

Category:sql Views:0 Time:2017-09-11
Tags: sql postgresql

Related post

  • How to find in all the tables containing columns having particular values? 2011-12-09

    My aim is to find all the table from database having the given column with particular value. i.e. I have tables like Table1,Table2,Table3,Table4,Table5,Table6, Table7 etc. In these tables, some of the tables have column name 'NameID'. Now I want to f

  • How to convert rows from multiple tables into columns with values in SQL Server 2005 2012-03-01

    I have one user table. and second language table which contains language that user can speak and third passport table which contains user's passport details(user can have multiple passport) [I have 5 more table except these] I want to convert these l

  • DELETE from mysql table WHERE column equals value AND column2 equals value2 2009-08-08

    Having some trouble getting this query to work correctly. mysql_query("DELETE FROM `table` WHERE `id` = '$id' AND 'username' = '$username' "); tried replacing variables with actual data and running it in phpmyadmin to no success any thoughts? -------

  • SQL: Update table where column = Multiple Values 2011-04-29

    I created an SQL query which updates a table column where another column = value CODE: Update Products Set ProductName = 'Shoes' WHERE ProductID = (1,2,3,4,5,6,7,8) The problem is with the ProductID. How can I make it update the column with those ID'

  • How to find out size of session in ASP.NET from web application? 2008-10-13

    How to find out size of session in ASP.NET from web application? --------------Solutions------------- If you're trying to get the size of Session during runtime rather than in debug tracing, you might want to try something like this: long totalSessio

  • how to find file's path according to filename? 2010-05-05

    i have filename according to this file name. i need to find file's path. how to find file's path according to filename? i need to find file's path according to file name sample code: string path= System.IO.Directory.GetDirectories(@"c:\", "kategori",

  • How to find the size of integer array 2010-05-05

    How to find the size of an integer array in C. Any method available without traversing the whole array once, to find out the size of the array. --------------Solutions------------- If the array is a global, static, or automatic variable (int array[10

  • Finding File size in bit 2010-09-21

    I need Exact size of File. is there anyway to find file size in bits (not byte). I do not want to find System.IO.FileInfo.Length and convert it to bits. Because this lose one byte information . --------------Solutions------------- It is not possible

  • How to find the size of a class in C# 2010-02-25

    public class A { int x; float y; } How to find the size of the class in C#. Is there any operator like Sizeof(), which used to be in C++ --------------Solutions------------- Short answer: You dont. Long answer: You can only do that if you type has a

  • how to find the size of a LINKED LIST (data structure) in c language? 2011-02-14

    how to find the size of a LINKED LIST (data structure) in c language? --------------Solutions------------- Here is how the function will look like. int size(Node *head) { int len = 0; while(head != null) { len++; head = head->next; } return len; }

  • How to Get File Size,File Name,File Ext In C# Windows? 2011-10-08

    im new to c#.net,any one let me know How to Get File Size,File Name,File Ext In C# Windows. im using open file dialog in c#..im getting only the path..i dont know how to get the file name and size.. my code is : openFileDialog1.ShowDialog(); openFile

  • how to find application size in blackberry by code? 2011-10-21

    i want to know how to find application size in blackberry by code? I want to display application name which are running along with its size on click of button, so how should i do it ? --------------Solutions------------- I gave some explanation pleas

  • how to get file size in javascript or jquery with rails 2012-04-13

    how to get file size in javascript or jquery with rails here by word size i means to say content size of file like 100kb. here i got some methods like size or file size but its not working for me my ruby code is <%= upload_form.file_field :upload_

  • An error message appears when I try to download a game how to find file Addon2Vb.DLL-run time 532 2012-09-27

    Original title: an error message appears when I try to download a game how to find file Addon2Vb.DLL error message run time 532 appears when I try to download a e-game --------------Solutions------------- Hi ArtLentz, Welcome to Microsoft Community.

  • How to reduce file size 2014-12-06

    How to reduce file size when is not apparent? 53K lines, 20 colums and it is 12.7MB. Any ideas? --------------Solutions------------- Use the suggested code here http://www.vbaexpress.com/kb/getarticle.php?kb_id=83 Best regards

  • I have a problem using windows update "how to find file qmgr0dat on my computer"? 2015-02-05

    Original Tittle: "how to find file qmgr0dat on my computer"? I have a problem using windows update, my computer is a hp window 7 64bit I have tried everything downloading this and that, nothing works, I need to to find Qmgr0 and Qmgr1.dat how do I fi

  • how to select * from tableA where columnA values don't start with letter 'F' 2010-05-20

    Can I have a SQL query to get the data from columna in tableA whose values don't start with 'f' ? For example: select * from tableA where columnA where values don't start with letter 'F'. --------------Solutions------------- SELECT columnA FROM table

  • How to retrieve data from two tables whose column names are the same 2010-03-10

    How to retrieve data from two tables whose column names are the same? --------------Solutions------------- If you want to include rows from both tables, you can use UNION ALL: SELECT Col1, Col2, Col3 FROM Table1 UNION ALL SELECT Col1, Col2, Col3 FROM

  • How to find the speed using x,y,z axis values? 2011-05-31

    hai,In my application i want to calculate the spped based on x,y,z values.So How to find the speed using x,y,z axis values ? --------------Solutions------------- Integrate the acceleration of each axis then add together the velocity vectors, and fina

  • How to find out size occupied by data table/data set in asp.net C#? 2012-04-11

    I am confused about size occupied by data table or data set. When a data table object is created then what is the size of that object and how it increases the size as required. Suppose a there is table with 10 rows in database having 5 columns and th

  • How to find the size of file 2010-07-09

    FILE=a.txt FILE_SIZE = `stat -c %s $FILE` if [ $FILESIZE >= 1000 ]; then cp $FILE /tmp/ # How to empty file ? then I am trying to get size of file and if the size is over limited and cp those file and empty the same file How to acheive this ? ----

  • Drupal : how to get file size of an image in views 2011-01-03

    I'm build an image gallery and want to display the filesize of an image along with the image thumbnail in a view. Can't figure out how to access this information and display it. Looked around for a module but can't find any. I am turning around. Glad

  • How to decrease file size of exported plots while keeping labels sharp 2012-01-03

    When exporting rather complicated plots (especially ListDensityPlot) as a PDF or EPS (for publication, for example), the resulting file size can be quite large. For example: data = Flatten[Table[{f0, f, Exp[-(f - f0)^2/25^2]}, {f0, 500, 700, 5}, {f,

  • how to get file size from meioupload behavior to print it 2012-01-14

    i use meioupload to upload files..but i want to save size for everyfile i uploaded..so how to use meioupload to get uploaded file size..and if it not support this option..are there anyway to do that.. models/download.php <?php class Download exten

Copyright (C) dskims.com, All Rights Reserved.

processed in 2.761 (s). 12 q(s)