How to get to get column name,datatype & length etc of a table.

By -
select column_name , data_type ,character_maximum_length from INFORMATION_SCHEMA.COLUMNS where table_name = 'donor_visit_details';



select * from INFORMATION_SCHEMA.COLUMNS where table_name = 'donor_visit_details';


Comments

Post a Comment

Popular posts from this blog

Simple way of importing and exporting excel, csv file for ruby on rails application using roo gem

By -
Image
Create a Rails Application where student data can upload as excel and can be download as excel file. #Gemfile gem 'roo' #Student Table migration File class CreateStudents < ActiveRecord::Migration   def change     create_table :students do |t|         t.string :name         t.integer :roll_no         t.integer :marks1         t.integer :marks2         t.integer :marks3         t.integer :avg       t.timestamps null: false     end   end end #student_controller.rb class StudentController < ApplicationController   def s_home     @products = Student.all     respond_to do |format|       format.html       format.csv { send_data @products.to_csv }       format.xls { send_data @products.to_csv(col_sep: "\t"), filename: 'your...
Read more

Ruby on Rails Gems Install & Implementation

By -
FIGARO: Purpose of Use. Figaro was written to make it easy to securely configure Rails applications. How to impliment . Step:1>>In Gemfile: gem 'figaro', '~> 1.1' Step:2>>$ bundle install or gem install figaro Step:3>>$ figaro install / rails generate figaro:install  It creates a commented config/application.yml file and adds it to your .gitignore.  Add your own configuration to this file and you're done! Step:4>> config/application.yml     DEV_DB_USERNAME: 'xx'   DEV_DB_PASSWORD: 'xxxxx'   DEV_DB_NAME: 'xxxxx' And here is my database.yml : development:   adapter: postgresql   encoding: unicode   database: <%= ENV['DEV_DB_NAME'] %>   pool: 5   username: <%= ENV['DEV_DB_USERNAME'] %>   password: <%= ENV['DEV_DB_PASSWORD'] %>   template: template0 AUDITED Purpose of Use. Audited (previously acts_as_audited) is an ORM extension that logs all changes to your models. Audited als...
Read more

Important Query for PostgreSQL

By -
Get All the Data of Table Select * from table_name; get the number of rows present table. Select count(*) from table_name; get dat of perticular column Select column_name from table_name; update data update table_name  set location_id = 10 # here whole location_id column will contain 10. if u want to update for specific row update table_name set mark = 100 where id = 1 Delete Data delete from table_name where id = 3  ---- one row delete from table_name where id in (3,6,7,8,9,11,12,13,16,17,18)  ---- multiple row alter table donor_visit_details_kgtemp  drop column weight --delete one column ALTER SEQUENCE table_name_id_seq RESTART with 107 # By this next ID will generate from 107 to onwards irrespecting of ID present
Read more