View Attach Info

Add new attachment

Only authorized users are allowed to upload new attachments.

This page (revision-9) was last changed on 15-Jan-2026 11:14 by BlakeMcBride

This page was created on 02-May-2011 21:13 by UnknownAuthor

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

At line 17 added 2 lines
\dn list schemas
set search path to <schema>;
At line 20 added 2 lines
\d table display schema for table
\pset pager off
At line 38 added one line
! Data Types
At line 40 added 23 lines
| smallint | 2
| integer | 4
| bigint | 8
| real | 4
| double precision | 8
| smallserial | 2
| serial | 4
| bigserial | 8
| money | 8
| char(n) |
| varchar(n) |
| text | variable length, unlimited
| bytea | binary, variable length
| timestamp | date and time | not null default current_timestamp
| date |
---------------------------------------------------------------------------
! Passing a password into psql
{{{export PGPASSWORD=ThePassword}}}
---------------------------------------------------------------------------
At line 67 added 2 lines
psql mydb postgres -f file-name >output.txt
At line 118 added 14 lines
!Clone a database
CREATE DATABASE <newdb> WITH TEMPLATE = <olddb>;
---------------------------------------------------------------------------
!Schemas
create schema <schema-name>;
drop schema <schema-name> cascade;
---------------------------------------------------------------------------
Version Date Modified Size Author Changes ... Change note
9 15-Jan-2026 11:14 6.53 kB BlakeMcBride to previous
8 13-Jul-2016 14:35 5.677 kB BlakeMcBride to previous | to last
7 20-Jun-2016 12:45 5.527 kB BlakeMcBride to previous | to last
6 15-Feb-2016 14:21 5.485 kB BlakeMcBride to previous | to last
5 10-Jul-2014 10:04 5.487 kB BlakeMcBride to previous | to last
4 18-Dec-2013 20:52 5.452 kB BlakeMcBride to previous | to last
3 17-Nov-2013 19:08 5.352 kB BlakeMcBride to previous | to last
2 24-Jul-2013 15:47 4.97 kB BlakeMcBride to previous | to last
1 02-May-2011 21:13 4.546 kB UnknownAuthor to last
« This page (revision-9) was last changed on 15-Jan-2026 11:14 by BlakeMcBride