Skip to content

Instantly share code, notes, and snippets.

@phil-lavin

phil-lavin/gist:edbc8b5c66edb54ef57b

Created May 13, 2014 17:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save phil-lavin/edbc8b5c66edb54ef57b to your computer and use it in GitHub Desktop.
Save phil-lavin/edbc8b5c66edb54ef57b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
bacula=> select * from pg_indexes where tablename='file';
schemaname | tablename | indexname | tablespace | indexdef
------------+-----------+----------------+------------+-----------------------------------------------------------------------------
public | file | file_pkey | | CREATE UNIQUE INDEX file_pkey ON file USING btree (fileid)
public | file | file_jobid_idx | | CREATE INDEX file_jobid_idx ON file USING btree (jobid)
public | file | file_jpfid_idx | | CREATE INDEX file_jpfid_idx ON file USING btree (jobid, pathid, filenameid)
(3 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment