top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

0 votes
436 views

Hi,

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 - https://www.postgresql.org/docs/current/static/app-pgdump.html

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
end

ActiveRecord::Base.class_eval do

# old rails versions
set_primary_key 'uuid'

before_create :generate_uuid
def generate_uuid
self.id = UUIDTools::UUID.random_create.to_s
end
end

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.

...