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

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

All About Route in Rails

By -
Image
What is HTTP? The Hypertext Transfer Protocol (HTTP) is designed to enable communications between clients and servers. HTTP works as a request-response protocol between a client and server. A web browser may be the client, and an application on a computer that hosts a web site may be the server. Get vs Post GET - Requests data from a specified resource. POST - Submits data to be processed to a specified resource. #Rails -- > config/route.rb root 'pages#index'   : default route (http://localhost:3000 it will go to this route) get 'authentication' => "login#authentication", (http://localhost:3000/authentication - it will goto login#authentication) get 'authentication' => "login#authentication", defaults: {format: 'json'}  now can represent data in json format.
Read more