In pgAdmin 4 right click on the database and then &quot;Generate ERD (Beta)&quot;

[![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/WbVVv.png

I have found [this webpage][1] on postgresql wiki, with various tools on utilizing a postgresql database. I have used DbWrench on Mac to generate the ERD.


  [1]: https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools

For pgadmin 3
Go to Tools -&gt; Query Tool

Graphical Query Builder is a tab in the Query Tool view.

unfortunately Pgadmin 4 does not have this option.

try pgModeler - there is working demo (although limited by number of objects). Also only PostgreSQL 9.x is supported. 


You can use JetBrains DataGrip for visualize your database schemas. Create a connection to DB, and right click on [shema name] -&gt; Diagrams -&gt; Show visualisation.

Everything is OK on Xcode4.6. When I try to use Xcode5 dp6 to run app on devices. I got an error of &quot;No matching provisioning profiles found issue&quot;. How can I resolve this issue?

![enter image description here][1]


  [1]: http://i.stack.imgur.com/0WUnA.png

Xcode5 &quot;No matching provisioning profiles found issue&quot; (but good at xcode4)

I wanted to start a Node app and created a ***package.json*** file with a tutorial. Here is the json file:

    {
        &quot;name&quot;: &quot;Dashboard&quot;,
        &quot;version&quot;: &quot;0.0.0&quot;,
        &quot;description&quot;: &quot;Client-A Dashboard&quot;,
        &quot;dependencies&quot;: {
            &quot;socket.io&quot;: &quot;latest&quot;,
            &quot;express&quot;: &quot;latest&quot;,
            &quot;jade&quot;: &quot;latest&quot;
        },
        &quot;author&quot;: &quot;tD&quot;
    }

I verified JSON file before trying to run it, but still I got an error message when I ran the `npm install` command:

	npm ERR! install Couldn&#39;t read dependencies
	npm ERR! Error: ENOENT, open &#39;C:\projects\Client-A\Live\package.json&#39;
	npm ERR! If you need help, you may report this log at:
	npm ERR!     &lt;http://github.com/isaacs/npm/issues&gt;
	npm ERR! or email it to:
	npm ERR!     &lt;npm-@googlegroups.com&gt;

	npm ERR! System Windows_NT 6.1.7601
	npm ERR! command &quot;C:\\Program Files (x86)\\nodejs\\\\node.exe&quot; &quot;C:\\Program Files (x86)\\nodejs\\node_modules\\npm\\bin\\npm-cli.js&quot; &quot;install&quot;
	npm ERR! cwd C:\projects\Client-A\Live\
	npm ERR! node -v v0.8.22
	npm ERR! npm -v 1.2.14
	npm ERR! path C:\projects\Client-A\Live\package.json
	npm ERR! code ENOENT
	npm ERR! errno 34
	npm ERR!
	npm ERR! Additional logging details can be found in:
	npm ERR!     C:\projects\Client-A\Live\npm-debug.log
	npm ERR! not ok code 0

and here is the ***npm-degub.log*** file

	0 info it worked if it ends with ok
	1 verbose cli [ &#39;C:\\Program Files (x86)\\nodejs\\\\node.exe&#39;,
	1 verbose cli   &#39;C:\\Program Files (x86)\\nodejs\\node_modules\\npm\\bin\\npm-cli.js&#39;,
	1 verbose cli   &#39;install&#39; ]
	2 info using npm@1.2.14
	3 info using node@v0.8.22
	4 verbose node symlink C:\Program Files (x86)\nodejs\\node.exe
	5 verbose read json C:\projects\Client-A\Live\package.json
	6 error install Couldn&#39;t read dependencies
	7 error Error: ENOENT, open &#39;C:\projects\Client-A\Live\package.json&#39;
	8 error If you need help, you may report this log at:
	8 error     &lt;http://github.com/isaacs/npm/issues&gt;
	8 error or email it to:
	8 error     &lt;npm-@googlegroups.com&gt;
	9 error System Windows_NT 6.1.7601
	10 error command &quot;C:\\Program Files (x86)\\nodejs\\\\node.exe&quot; &quot;C:\\Program Files (x86)\\nodejs\\node_modules\\npm\\bin\\npm-cli.js&quot; &quot;install&quot;
	11 error cwd C:\projects\Client-A\Live\scoreboard
	12 error node -v v0.8.22
	13 error npm -v 1.2.14
	14 error path C:\projects\Client-A\Live\package.json
	15 error code ENOENT
	16 error errno 34
	17 verbose exit [ 34, true ]




&quot;Couldn&#39;t read dependencies&quot; error with npm

I am trying to visualize tables and their relations using pgAdmin. I have understood that there is a [query visualizer tool][1] available for pgAdmin. However, that only is useful if you are dealing with queries. My main goal is to generate a graphical representation of all the tables available in database.


  [1]: http://link.sheidaei.com/byqyv

How to visualize database tables in postgresql using pgAdmin?

<p>I am trying to visualize tables and their relations using pgAdmin. I have understood that there is a <a href="http://link.sheidaei.com/byqyv" target="_blank" rel="noopener noreferrer">query visualizer tool</a> available for pgAdmin. However, that only is useful if you are dealing with queries. My main goal is to generate a graphical representation of all the tables available in database.</p>


I have a table which holds data, and one of those rows needs to exist in another table. So, I want a foreign key to maintain referential integrity.


    CREATE TABLE table1
    (
       ID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
       AnotherID INT NOT NULL,
       SomeData VARCHAR(100) NOT NULL
    )
    
    CREATE TABLE table2
    (
       ID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
       AnotherID INT NOT NULL,
       MoreData VARCHAR(30) NOT NULL,
    
       CONSTRAINT fk_table2_table1 FOREIGN KEY (AnotherID) REFERENCES table1 (AnotherID)
    )

However, as you can see, the table I foreign key to, the column isn&#39;t the PK. Is there a way to create this foreign key, or maybe a better way to maintain this referential integrity?

Foreign Key to non-primary key

I am trying to load data into mysql database using

    LOAD DATA LOCAL
    INFILE A.txt
    INTO DB
    LINES TERMINATED BY &#39;|&#39;;

the topic of this question is the response I get. I understand the local data offloading is off by default and I have to enable it using a the command `local-infile=1` but I do not know where to place this command.

ERROR 1148: The used command is not allowed with this MySQL version

I have a little problem and hoping someone can give me some advice. I am running a SQL command, but it appears it takes this command about 2 mins to return the data as there is a lot of data. But the default connection time is 30 secs, how do I increase this, and apply it to this command? 

    public static DataTable runtotals(string AssetNumberV, string AssetNumber1V)
    {
        DataTable dtGetruntotals;

        try
        {
            dtGetruntotals = new DataTable(&quot;Getruntotals&quot;);

            //SqlParameter AssetNumber = new SqlParameter(&quot;@AssetNumber&quot;, SqlDbType.VarChar, 6);
            //AssetNumber.Value = AssetNumberV; 

            SqlParameter AssetNumber = new SqlParameter(&quot;@AssetNumber&quot;, SqlDbType.VarChar, 10);
            AssetNumber.Value = AssetNumberV;

            SqlParameter AssetNumber1 = new SqlParameter(&quot;@AssetNumber1&quot;, SqlDbType.VarChar, 10);
            AssetNumber1.Value = AssetNumber1V;

            SqlCommand scGetruntotals = new SqlCommand(&quot;EXEC spRunTotals @AssetNumber,@AssetNumber1 &quot;, DataAccess.AssetConnection); 
            // scGetruntotals.Parameters.Add(AssetNumber);
            scGetruntotals.Parameters.Add(AssetNumber);
            scGetruntotals.Parameters.Add(AssetNumber1);

            SqlDataAdapter sdaGetruntotals = new SqlDataAdapter();
            sdaGetruntotals.SelectCommand = scGetruntotals;
            sdaGetruntotals.Fill(dtGetruntotals);

            return dtGetruntotals;
        }
        catch (Exception ex)
        {
            MessageBox.Show(&quot;Error Retriving totals Details: Processed with this error:&quot; + ex.Message);
            return null;
        }
    }

Increasing the Command Timeout for SQL command

I&#39;m using PostgreSQL 9.1. I have the column name of a table. Is it possible to find the table(s) that has/have this column? If so, how?

How to find a table having a specific column in postgresql

In my PostgreSQL database I have a unique index created this way:

    CREATE UNIQUE INDEX &lt;my_index&gt; ON &lt;my_table&gt; USING btree (my_column)

Is there way to alter the index to remove the unique constraint? I looked at [ALTER INDEX documentation][1] but it doesn&#39;t seem to do what I need.

I know I can remove the index and create another one, but I&#39;d like to find a better way, if it exists.

  [1]: http://www.postgresql.org/docs/8.2/static/sql-alterindex.html

Remove uniqueness of index in PostgreSQL

If someone can provide some insights here I would GREATLY appreciate it. 

I am new to MongoDB, and (relatively) new to the command line. 

I had a express/node.js app running on MongoDB locally successfully, but upon restarting my computer, I attempted to restart the Mongo server and it began giving errors and wouldn&#39;t start. Since then, I have re-installed Mongo several times only to find the same error occurring. this is what I am receiving:

    privee:mongodb-osx-x86_64-2.4.6 jonlinton$ ./bin/mongo
    MongoDB shell version: 2.4.6
    connecting to: test
    Mon Aug 26 14:48:47.168 Error: couldn&#39;t connect to server 127.0.0.1:27017 at     src/mongo/shell/mongo.js:145
    exception: connect failed

Am I missing a step? Should I be creating a config file? Some basic guidance would be really helpful. Thanks in advance for any insights.

Installing and Running MongoDB on OSX

On a non-rooted android device, I can navigate to the data folder containing the database using the `run-as` command with my package name. Most files types I am content with just viewing, but with the database I would like to pull if from the android device.

Is there a `download` `copy` or `move` command from this part of adb shell? I would like to download the database file and view its content using a database browser.

One answer here involves turning entire application package into a compressed archive, but there is no further answer on how to extract that archive once this is done and moved to the machine, leaving me very sidetracked when there might be a more direct solution to begin with

Retrieve database or any other file from the Internal Storage using run-as

I&#39;ve considered creating a Vertices table and an Edges table but would building graphs in memory and traversing sub-graphs require a large number of lookups? I&#39;d like to avoid excessive database reads. Is there any other way of persisting a graph? 

Side note: I&#39;ve heard of Neo4j but my question is really how to conceptually represent a graph in a standard database. I am open to some NoSQL solutions like mongodb though.

How to persist a graph data structure in a relational database?

I have PostgreSQL 9.2 Installed in Windows 7 and I have windows XP installed in Virtual Machine, how do I connect these two databases and allow remote access to add/edit the database from both Systems ?

How to Allow Remote Access to PostgreSQL database

Is it more efficient to create an index after loading data is complete or before, or does it not matter? 

For example, say I have 500 files to load into a Postgres 8.4 DB. Here are the two index creation scenarios I could use:

 1. Create index when table is created, then load each file into table; or
 1. Create index after all files have been loaded into the table.

The table data itself is about 45 Gigabytes. The index is about 12 Gigabytes. I&#39;m using a standard index. It is created like this:

    CREATE INDEX idx_name ON table_name (column_name);

My data loading uses [COPY FROM][1].

Once all the files are loaded, no updates, deletes or additional loads will occur on the table (it&#39;s a day&#39;s worth of data that will not change). So I wanted to ask which scenario would be most efficient? Initial testing seems to indicate that loading all the files and then creating the index (scenario 2) is faster, but I have not done a scientific comparison of the two approaches.


  [1]: http://www.postgresql.org/docs/8.1/static/sql-copy.html &quot;COPY FROM&quot;

Most Efficient Way to Create an Index in Postgres

I&#39;m getting the error:

    FATAL: Peer authentication failed for user &quot;postgres&quot;

when I try to make postgres work with Rails. 

Here&#39;s my [`pg_hba.conf`][1], my [`database.yml`][2], and a [dump of the full trace][3].

I changed authentication to md5 in pg_hba and tried different things, but none seem to work. 

I also tried creating a new user and database as per https://stackoverflow.com/questions/9987171/rails-3-2-fatal-peer-authentication-failed-for-user-pgerror

But they don&#39;t show up on pgadmin or even when I run `sudo -u postgres psql -l`.

Any idea where I&#39;m going wrong?


  [1]: http://pastebin.com/4V1sMS01
  [2]: http://pastebin.com/mS0G6Srp
  [3]: http://pastebin.com/bXg1Pkr5

Getting error: Peer authentication failed for user &quot;postgres&quot;, when trying to get pgsql working with rails

I have pgAdmin version `1.16.1`

So, for exporting table dumm I do:

Right click on table, then  in menu click on `backup`, then in `Format` choice `Plain` and save file as `some_name.sql` 


Then I remove table.

Ok, now I need import table backup `some_name.sql` into database.

How to do this?  I can&#39;t find how to import table&#39;s `.sql` dump into database using pgAdmin. 

Can you help me please?

Export and import table dump (.sql) using pgAdmin

Is there any plugin or library which I need to use for this?
I want to try this on my local system first and then do the same on Heroku Postgresql

How should I import data from CSV into a Postgres table using pgAdmin 3?

I installed Postgres with this command

    sudo apt-get install postgresql postgresql-client postgresql-contrib libpq-dev

Using `psql --version` on terminal I get `psql (PostgreSQL) 9.3.4`

then I installed ``pgadmin`` with

    sudo apt-get install pgadmin3

Later I opened the UI and create the server with this information

![enter image description here][1]


but this error appear


![enter image description here][2]

how can I fix it?

  [1]: http://i.stack.imgur.com/89CrA.png
  [2]: http://i.stack.imgur.com/ClRbk.png

How to connect Postgres to localhost server using pgAdmin on Ubuntu?

I have created an ubuntu image with nginx, php and postgres.

I want to connect the postgres database in my current image with `pgadmin` located on my local machine. 

I have tried using docker inspector to try to use the image ip to make a connection with my local pgadmin but without much success. I&#39;ve also tried configuring some ports on local to make connection work.

docker postgres pgadmin local connection

installed PSQL10 but when pgAdmin is run from start then always open in browser.There is no option to run as a Desktop Application

Content Type	Original Author	Original Content on Stackoverflow
Question	sheidaei	View Question on Stackoverflow
Solution 1 - Sql	midi	View Answer on Stackoverflow
Solution 2 - Sql	sheidaei	View Answer on Stackoverflow
Solution 3 - Sql	user2669758	View Answer on Stackoverflow
Solution 4 - Sql	karl	View Answer on Stackoverflow
Solution 5 - Sql	Swatar Common	View Answer on Stackoverflow

How to visualize database tables in postgresql using pgAdmin?

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

Solution 4 - Sql

Solution 5 - Sql

"Couldn't read dependencies" error with npm

Xcode5 "No matching provisioning profiles found issue" (but good at xcode4)

Attributions