User Neil McGuigan

6 votes

What is the best practices for storing sales tax rates?

answered Mar 15, 2016 at 22:52

6 votes

Accepted

Create Materialized View from foreign table

answered Jun 3, 2016 at 19:24

6 votes

Accepted

What are we Doing when we Connect to SQL Server?

answered Aug 19, 2016 at 2:17

5 votes

Accepted

Why is Server Configuration in Pgadmin3 inaccessible for me?

answered May 24, 2017 at 23:25

5 votes

Need help designing table with list of IDs to store

answered Jul 26, 2013 at 4:27

5 votes

Accepted

How to determine if postgres database contains GiST indexes and what type?

answered Aug 8, 2014 at 0:09

5 votes

Accepted

What's the quickest way to periodically export PostgreSQL data to a local file on Windows?

answered Aug 19, 2015 at 23:19

5 votes

Modeling invoices and orders

answered Jul 3, 2015 at 22:27

4 votes

Accepted

Alternatives to NULL for missing data

answered Apr 30, 2014 at 0:52

4 votes

Does the PostgreSQL COPY command have the option of choosing which fields to map the CSV columns to?

answered Mar 18, 2016 at 18:53

4 votes

Is it ever good practice to use a distinct database account for each user of an application?

answered Mar 25, 2016 at 20:35

4 votes

Accepted

Two substantially different but similar cases: Are they the same in terms of table cadinality?

answered Feb 13, 2020 at 22:45

3 votes

Import CSV in Postgres with static data in other columns

answered Jul 30, 2016 at 22:44

3 votes

Limited utility in RECURSIVE VIEWS?

answered May 11, 2016 at 19:48

3 votes

Accepted

How can I query for terms like "@foo" with Postgres full text search?

answered Jul 20, 2017 at 20:37

3 votes

Why add indexes to these columns in the Database?

answered Nov 12, 2013 at 10:00

3 votes

Enforcing database integrity

answered Apr 16, 2012 at 21:45

3 votes

Coding an accounting database from scratch?

answered Jan 30, 2013 at 19:00

3 votes

What free database software support sequences

answered Jul 16, 2012 at 4:53

3 votes

Accepted

Complete list of possible database "objects"?

answered Jun 26, 2012 at 20:37

3 votes

Multiple parents and multiple children in product categories

answered Feb 23, 2013 at 20:26

3 votes

Should I create a separate user table for different web products within the same platform?

answered Feb 25, 2013 at 18:59

3 votes

Accepted

Open source and commercial tools to build dynamic queries of fact tables in star schema

answered Feb 6, 2013 at 4:07

3 votes

PostgreSQL: Foreign key on string column

answered Jan 27, 2015 at 19:14

3 votes

Performance impact of adding a foreign key to a 1M rows table

answered Jun 29, 2015 at 20:40

3 votes

Fuzzy Matching with Postgresql 9.3

answered Oct 16, 2014 at 21:23

3 votes

Importing CSV into multiple tables using PostgreSQL

answered Feb 10, 2016 at 19:02

3 votes

Get column names and data types of a query, table or view

answered Aug 27, 2014 at 0:38

3 votes

Accepted

Building dependence between regional data (Street -> City -> PostalCode -> Country)

answered Sep 10, 2014 at 17:22

3 votes

Is my ERD valid for airports,cities and airlines database?

answered May 9, 2014 at 17:44

Stack Exchange Network

192 Answers

What is the best practices for storing sales tax rates?

Create Materialized View from foreign table

What are we Doing when we Connect to SQL Server?

Why is Server Configuration in Pgadmin3 inaccessible for me?

Need help designing table with list of IDs to store

How to determine if postgres database contains GiST indexes and what type?

What's the quickest way to periodically export PostgreSQL data to a local file on Windows?

Modeling invoices and orders

Alternatives to NULL for missing data

Does the PostgreSQL COPY command have the option of choosing which fields to map the CSV columns to?

Is it ever good practice to use a distinct database account for each user of an application?

Two substantially different but similar cases: Are they the same in terms of table cadinality?

Import CSV in Postgres with static data in other columns

Limited utility in RECURSIVE VIEWS?

How can I query for terms like "@foo" with Postgres full text search?

Why add indexes to these columns in the Database?

Enforcing database integrity

Coding an accounting database from scratch?

What free database software support sequences

Complete list of possible database "objects"?

Multiple parents and multiple children in product categories

Should I create a separate user table for different web products within the same platform?

Open source and commercial tools to build dynamic queries of fact tables in star schema

PostgreSQL: Foreign key on string column

Performance impact of adding a foreign key to a 1M rows table

Fuzzy Matching with Postgresql 9.3

Importing CSV into multiple tables using PostgreSQL

Get column names and data types of a query, table or view

Building dependence between regional data (Street -> City -> PostalCode -> Country)

Is my ERD valid for airports,cities and airlines database?