top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

In postgresql shell how to select the database and list the tables?

0 votes
340 views

Using PostgreSQL shell how to select the database and tables.

posted Jul 30, 2018 by anonymous

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

1 Answer

0 votes

\c command use to select the database in the table

For Example

\c databasename

\dt command is used to select the table

answer Jul 31, 2018 by Sandeep Bedi
Similar Questions
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.

0 votes

Hi,

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

+1 vote

Joiner using how to get three tables value fetching from single query.

...