/indian_banks

Dump of PostgreSQL tables with IFSC codes of bank branches.

Indian Bank IFSC Codes

Based on MySQL dump which, in turn, is based on the unwieldy excel file from RBI. I doubt if I'll be updating this very often, but am happy to accept pull requests. Things that could come in are MICR codes, SWIFT codes.

CSV Dump

See bank_branches.csv file. If you prefer a PostgreSQL dump for building a service or some such, look at the .sql file.

Dump of PostgreSQL tables with IFSC codes of bank branches.

The SQL dump has two table and one view.

  • banks - has two columns id and name (e.g. ICICI). The id was generated by me and is not universal.
  • branches - has details of all branches. IFSC code is the primary key of this table. Has bank_id which is a foreign key reference into banks table.
  • bank_branches - view on top of these tables that joins on bank_id. Convenient if you want to search by bank name
bank=# \d banks
            Table "public.banks"
 Column |         Type          | Modifiers 
--------+-----------------------+-----------
 name   | character varying(49) | 
 id     | bigint                | not null
Indexes:
    "banks_id_pkey" PRIMARY KEY, btree (id)
Referenced by:
    TABLE "branches" CONSTRAINT "branches_banks_fkey" FOREIGN KEY (bank_id) REFERENCES banks(id)

bank=# \d branches
            Table "public.branches"
  Column  |          Type          | Modifiers 
----------+------------------------+-----------
 ifsc     | character varying(11)  | not null
 bank_id  | bigint                 | 
 branch   | character varying(74)  | 
 address  | character varying(195) | 
 city     | character varying(50)  | 
 district | character varying(50)  | 
 state    | character varying(26)  | 
Indexes:
    "branches_ifsc_pkey" PRIMARY KEY, btree (ifsc)
Foreign-key constraints:
    "branches_banks_fkey" FOREIGN KEY (bank_id) REFERENCES banks(id)

bank=# \d bank_branches
          View "public.bank_branches"
  Column   |          Type          | Modifiers 
-----------+------------------------+-----------
 ifsc      | character varying(11)  | 
 bank_id   | bigint                 | 
 branch    | character varying(74)  | 
 address   | character varying(195) | 
 city      | character varying(50)  | 
 district  | character varying(50)  | 
 state     | character varying(26)  | 
 bank_name | character varying(49)  |

Usage

psql <database> < indian_banks.sql
CREATE TABLE
CREATE TABLE
CREATE VIEW
COPY 170
COPY 127857
ALTER TABLE
ALTER TABLE
ALTER TABLE