LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 01-14-2008, 06:57 AM   #1
nautilus
Member
 
Registered: Jun 2007
Location: London, Athens
Distribution: Debian, Ubuntu
Posts: 36

Rep: Reputation: 15
How to find out which tables are partitioned and info about data files in Postgres


Hello guys.

Does anyone out there know how I can find out with an SQL query (NOT from the shell!) if a table is partitioned? Maybe a select in the system catalogs? I went through all the tables and views there but no luck... I only found out if an index is partitioned, by doing:

Quote:
select c.relname, i.indisclustered from pg_index i INNER JOIN pg_class c on c.oid = i.indexrelid;
Any ideas?

I am also looking into how I can find out with an SQL query (again, NOT from a shell!) the actual and maximum size of each datafile in an PostgreSQL server.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to know the command which shows all non-partitioned & partitioned hard drive saidul Linux - Newbie 2 12-04-2007 04:02 PM
Find out how a disk was partitioned flycast Linux - Hardware 4 04-14-2007 08:04 PM
Dynamically select data from MySQL tables tangle Programming 6 02-28-2006 05:48 PM
postgres data jamna17 Linux - Newbie 4 04-07-2004 05:45 AM
Hard drive partitioned and cannot view files Johnny2003 Linux - Newbie 4 01-20-2004 07:22 PM


All times are GMT -5. The time now is 06:19 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration