top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

In Postgresql, How to take dumb only the DB schema?

0 votes


I need to take the only schema from Postgresql. Can anyone suggest how to dumb or migrate the schema?

posted Jul 16, 2018 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

With using pg_dump we can create a dump

pg_dump — extract a PostgreSQL database into a script file or other archive file

Read more details here -

answer Aug 25, 2018 by Sandeep Bedi
Similar Questions
0 votes

Using PostgreSQL shell how to select the database and tables.

0 votes

Error Details:

Resolve "FATAL:no pg_hba.conf entry for host"

Anyone suggest how to solve this error?

+3 votes

I am using rails 3.1 and ruby 1.9.3,Now i want to use uuid concept in rails 3 for existing data

so I did like :-

create_table :posts, :id => false do |t|
 t.string :uuid, :limit => 36, :primary => true

ActiveRecord::Base.class_eval do

# old rails versions
set_primary_key 'uuid'

before_create :generate_uuid
def generate_uuid = UUIDTools::UUID.random_create.to_s

This is working for new data,now i want to migrate existing data with relation.for uuid they are using datatype as string,in postgresql the data type used for primary_key and foreign key is integer ,so if i am trying to change foreign key integer to string it is throwing error. Can someone please tell me some example,how to do this.

Contact Us
+91 9880187415
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Karnataka INDIA.